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.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-20 : 08:30:48
|
| Hi allI have been contiuously getting compliants from developers..that the database is very slow..The database is of size 45GBAround 10 users are currently connected to the this database server..I don't know what are the steps i should take to check when this issue arises..as per my knowledge.. i went to EM-Management-Current Activity-Locks/objects there i found some of the table namess including some systemd tables from msdb and tempdb..how can i resolve and come to the conclusion of cause of slowness of the database..This is a common issue that i am facing..any help on this is grealy appreciated...Thanks in advance.. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-20 : 08:48:53
|
| Add this sp to masterhttp://www.nigelrivett.net/SQLAdmin/sp_nrInfo.htmlWhen you run it it will show what is happenning on the server.Look at things with rapidly increasing disk io. It shows the instruction running and when the batch started.That should show what you need to look at.It also shows things that are blocking and the command. If that happens you should deal with it. Stop the user running that query and kill it if necessary (again look at the start time and decide if that user will get more upset than the ones being blocked.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Database is slow