January 9, 2006 at 11:04 am
Question,
Our users are reporting slow app response. Here's the sql server profile. Does anything strike you as wrong or can you suggest other counters I should look at?
Server
Windows 200 SP4
SQL 2000, SP 3
Installed memory: 4GB
RAID 5 configuration
Perfmon data:
Available MBytes (Memory): 1772 (I think the max this can be, without the /3GB switch in boot.ini, is 2GB. So we are doing pretty good).
Percent CPU time: hovers asorund 50% (dual CPU)
Disk usage (total) 3-4%
Paging faults/sec (Memory): hovers around 350
Average disk queue length: < .08
Drive C has 40GB free; dirve D; as 100GB free.
%Usage (page file) < 0.2
TIA,
Bill
January 9, 2006 at 11:52 am
You should probably use SQL Server Profiler and trace at the SQL Server level rather than the operating system to determine what SQL is coming from the app to the server and how it is being processed.
This is a large subject area - maybe search the articles here for resources on using and interpretting profiler.
January 10, 2006 at 10:47 am
Is your TempDB has an adequate sizing?
January 10, 2006 at 10:58 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
Round II
DBCC DBREINDEX
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
Round III
Profiler
Query Hints
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 10, 2006 at 10:58 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
Round II
DBCC DBREINDEX
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
Round III
Profiler
Query Hints
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply