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 |
|
Harry C
Posting Yak Master
148 Posts |
 Posted - 2010-06-05 : 03:06:29
|
| Hi, I have one server with 8 identical databases on them. They have varying amounts of data, but the schema is the same. 4 of the databases run just fine, but the others are taking forever to load any pages. Here is the setup, we have 8 customers and each customer has their own IIS website and their own database. The DBs are identical with different amounts of data in them. But none are huge. All under 100MBSay for example I run site 1 attached to DB 1 and it runs fine. Then I attach site 1 to DB 2 and it runs slow. It just seems that certain DBs run slow (always the same ones) and the others run ok. I can't figure this out? How can I debug this? I also ran SQL compare and the DBs are indentical. Help! ThanksHC |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
databases running slow