Wednesday, March 21, 2012

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisRare you queries running on the client side or are they in stored
procedures on the server side?|||are you queries running on the client side or are they in stored
procedures on the server side?|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegroups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

No comments:

Post a Comment