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 |
|
leodone
Starting Member
30 Posts |
 Posted - 2010-07-28 : 15:57:39
|
| Hello everyone,We are having performance issues with one our SQL Server 2005 database. We have about 9 sql database on one server.Example of my issue:Database 1Database 2Database 3Database 4We have a problem with performance with Database 1 but everything in Database 1 is fined tuned. Question: How can I know if Database 2 or 3 or 4 is cause the performance issue on Database 1?Please help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-28 : 16:29:44
|
| I've never seen a database that was perfectly tuned, and that includes ones that I tuned for a couple of years straight.It could be that queries in the other DBs are using memory and CPU that is affecting DB 1. It's more likely that with data growth, the queries and indexes in DB 1 need to be revised, indexes rebuilt and statistics updated.[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Database Performance