check database activity - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

check database activity

Author

Topic

magmo
Aged Yak Warrior

558 Posts

Posted - 2008-10-21 : 09:48:34

Hi

Sometimes it seems like our sql server is under heavy work, beacuse it can take very long time to execute stored procedures and so on, how can I check whats going on that makes the server responding so slow?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-21 : 09:59:45

Any error in app log or error log about I/O issues or Memory issue(paging out).It could be caused by various issues
1)fragmented index
2)stats not upto date
3)Recompiling everytime you run it

Run performance monitor .

magmo
Aged Yak Warrior

558 Posts

Posted - 2008-10-21 : 10:46:01

Found the error, the logfile was huuuuge.

ghemant
Starting Member

22 Posts

Posted - 2008-10-23 : 08:43:32

quote:
Originally posted by magmo

Hi

Sometimes it seems like our sql server is under heavy work, beacuse it can take very long time to execute stored procedures and so on, how can I check whats going on that makes the server responding so slow?

then you should consider investigation of this; something like autogrow, reindex,bulk insert/bcp etc. you should also consider scheduling t-log backup to keep your t-log in shape.

Regards
Hemantgiri S. Goswami
MS SQL Server MVP
http://hemantgirisgoswami.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources