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 |
|
britnostalgic
Starting Member
1 Post |
 Posted - 2010-04-13 : 08:36:48
|
| Hi,A bit of history on the Problem I have:The server intermittently slows at various hours throughout the day, users complain about slowness, and I can see when using perfmon that the disks and CPU are being hammered. When this is happening, is there a way to single out which database is causing the problem? Simply to digg a little deeper into the problem. I suspect the storage also i.e. log placement and database locations. But I need more info on this database before I can move things forward. Any ideas peeps?System overview:Windows 2003 STD x64 Edition24GB RAMIntel Zeon 2.50Ghz (8x dual core CPU's)Microsoft SQL Server 2005 / 9.0.4035EMC SAN STORAGE, across several spindles where logs and data are stored.Background info:This SQL server holds around 5 instances, and 50 ish databases. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Performance issue?