July 29, 2002 at 12:00 pm
We're getting random slowness issues at various client
sites. No patterns seem to be occuring and periods of
slowness do not seem to be triggered by anything notable.
We've been monitoring major objects\counters on and off
and are going to try to track approx 6 hours a day, for a
week straight and establish a current baseline, and then
after applying a fix, we'll montior again to determine if
there's any improvements.
Again, we're tracking all the major players here, Memory,
Processor, Physical Disk, Server, and all the necessary
SQL objects we're looking for. In addition, other DBA's
are setting up Profiler to track various specific activity
within SQL itself.
My question is, is anyone familiar with any other objects
that might reveal something\anything? I'm not familiar
with any network objects and wonder if some of those
apply. Typically we'll see slowness occur on the SQL
Server, with paging, and of course more RAM is usually the
recommendation. But we're beyond that now and want to
know if maybe something is forcing SQL to buffer and hold
on to it's data longer than it should be. i.e., Perhaps
there's some issue between the client (or on the client)
and SQL Server.
If you've got any info, links, etc, that would be much
appreciated.
Thanks,
Kevin
July 29, 2002 at 12:03 pm
It could be the network, but its usually the last place I look if the network looks to be reasonably responsive. Have someone check the switch its connected to for an unusually high number of errors - if you see that its worth putting more time in to.
Andy
July 29, 2002 at 2:29 pm
It sounds that your troubleshooting is focusing on system level (resources and networking). I would like suggest you to pay attention to the behaviour of the application first. Specially, you can use sp_lock and sp_who periodically to observe if
1) some locks hold too long, and
2) some user processes block others.
If you can find out something that is not you expected, then figour out whether it is caused by application coding or system configuration.
Jian
July 31, 2002 at 8:51 am
Thanks for your responses.
We have other DBA's handling profiles and all the internal workings of SQL. And we're trying to correlate (or not) any issues with code and trends in performance.
But the problem I'm having is viewing my counters that have been tracked. I specify them to be monitored, but when I bring the log up in System Monitor, it tells me those counters are not there.
I have already reviewed the following article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q152513
These are the same symptoms I'm experiencing, but performing these steps has not provided any relief.
The main objects I'm not able to view are: Memory - Pages\Sec, and several sql objects including BufferManger\Buffer cache hit ratio, General Statistics\User Connections, and Latches. But I can view Locks.
The strange thing is that I record the logs in a CSV format (comma delimited text file) that imports directly into Excel. I can view these objects there, and can see what the results were for each incremented trace, but System Monitor doesn't seem to be able to see them.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply