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 |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2009-07-15 : 09:06:53
|
| HelloCan anyone help me with the steps required to perform tuning on a database engine.?So far everytime i run the database tuning component, I get the suggestion from the SQL Server 2005 that my database is perfect with no re-indexing / changes necessary (Though i know there are lot of inconsistencies with my database tables)Any help in this direction is deeply appreciated.Thanks in advanceSrivatsa |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-15 : 09:42:45
|
| What size workfile are you using? You need something faily complex to get decent suggestions for the whole database. The easiest way is to know when your database is hit by a lot of queries and have a trace running to collect the SQL, then use this as your basis for the workload. |
 |
|
|
|
|
|
Database Engine Tuning Advisor Help !!