Well, with my server, it means my pager goes off! =B)
Seriously, the server will wait for a free lock until it times out, at
which point it throws an ODBC error back to the person whose request could
not get locked and an SQL error to the server's error event engine. If you
want the exact text, I'll dig through a log file and get it.
It's not a very pretty situation, since the user does get a big, nasty ODBC
error in their face (if you don't have an error handling framework in
place) and there's no telling what stored procedure or automatic
maintenance job might have gotten whacked. The good part is that the
server doesn't start disk swapping, because SQL Server stops trying to
allocate Locks when the next lock allocation would force a swap. It also
throws the error instead of violating your dB integrity, so the worst thing
is that your user waits a minute and then tries again.
I highly recommend that you set up your SQL Server event engine with your
email address and pager number, and have it notify you of these sorts of
things. It's really easy to do from Enterprise Manager, and it sure makes
you look good when you can know of the problem ahead of your boss...
|--------------+----------------------------------------------------------|
|Eric A. Laney |All the little things you and I understand and expect from|
|Systems |life, such as: equality; kindness; justice... |
|Engineer | |
|LAN | |
|Optimization | - Spock, "The Cloud Minders," stardate 5818.4.|
|Team | |
|Voice: | |
|813.978.4404 | |
|Pager: | |
|888.985.8519 | |
|--------------+----------------------------------------------------------|
"Bill
Davidson" To: CF-Talk <[EMAIL PROTECTED]>
<bill@intrage cc:
t.com> Subject: Re: SQL Server memory use grows
07/25/2001
05:07 PM
Please
respond to
cf-talk
Eric -
What's the behavior when it runs out of locks?
Regards.
-Bill
www.brainbox.tv
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 1:27 PM
Subject: RE: SQL Server memory use grows
>
> My SQL Server 7.0 box has 512MB and does nothing but SQL. The last time
I
> rebooted it to do a hotfix, it was running with over 400MB of RAM
dedicated
> to SQL Server. The only problem I run into is when I get a big spike of
> activity and the server runs out of Locks. I'll be moving my Client
> variable data store to a different SQL server soon, which should
alleviate
> that problem.
>
> In short, I don't think 140MB is anywhere close to being a problem.
>
|-----------------------------+-------------------------------------------|
> |Eric A. Laney |The closed mouth swallows no flies.
|
> |Systems Engineer |
|
> |LAN Optimization Team |
|
> |Voice: 813.978.4404 | - Spanish
proverb|
> |Pager: 888.985.8519 |
|
>
|-----------------------------+-------------------------------------------|
>
>
>
>
>
>
> "John Fix 3rd"
> <john3list@cor To: CF-Talk
<[EMAIL PROTECTED]>
> nells.com> cc:
> Subject: RE: SQL Server
memory use grows
> 07/25/2001
> 12:31 PM
> Please respond
> to cf-talk
>
>
>
>
>
>
> There's 512mb installed right now. OK, if that doesn't seem out of
> line, then I'll leave it for a longer period next time and see what
> happens.
>
> Thanks!
>
> John
>
> > -----Original Message-----
> > From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 25, 2001 10:46 AM
> > To: CF-Talk
> > Subject: RE: SQL Server memory use grows
> >
> >
> > 140MB? that sounds like SQL, not a memory leak. you can
> > restrict the amount of memory (or range thereof) SQL uses.
> > how much RAM is on your SQL server? it really shouldn't be
> > less than 512MB and ideally, 1GB+.
> >
> > -----Original Message-----
> > From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 25, 2001 7:27 AM
> > To: CF-Talk
> > Subject: SQL Server memory use grows
> >
> >
> > I finally moved some of our Cold Fusion Access databases to
> > SQL Server 7 on a separate server. Things are running well,
> > but I notice that over several days SQL uses more and more
> > memory. It starts at about 40mb but is now running at about
> > 90mb. When I restarted the service a few days ago, it was up
> > to about 140mb. Sounds like a memory leak somewhere, but I
> > need some ideas where to look.
> >
> > Thanks!
> >
> > John
> > www.cornells.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
