Link to home
Start Free TrialLog in
Avatar of meteorelec
meteorelecFlag for Ireland

asked on

Performance Analysis of SQL 2005 database

hi

i have a SQL production server that has started to get quite slow when using various parts of the front end application. Tasks that used to take a second to commit now take 5-6 seconds.

Can anyone advise on
1) good general steps on performance analysis
2) any features/configs to look out for that may be enabled that cause performance issues
3) anything server specific that i could change etc

i am running sql 2005 on server 2003 ent

Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of meteorelec

ASKER

cheers guys, ill have a read at these and see how i get on

ill be back with questions im sure!
ok, i ran perf mon for a day or so , and have alot of facts and figures
 
the stats that stand out immediatly are
1)PhysicalDisk(1 D:)\Avg. Disk Queue Length - max is getting up to 187 to as low as 0
2)PhysicalDisk(1 D:)\ % Disk Time 17386.9988397381 to as low as  0
 
disk D is where the sql database is installed, are these numbers maybe normal enough for daily operation? or are they a sign of an issue?
got the issue!
 
 there is 4 databases running on the server, each had full recovery mode enabled which as soon as i switched to simple recovery mode i am back at full speed

performance monitor helped greatly as the stats reflected immedialty a difference when i disabled the logging

cheers for the help guys!