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 |
Luuk123
Yak Posting Veteran
52 Posts |
Posted - 2012-11-26 : 05:54:55
|
Hi All,Is there a way to optimize my database so performance would get better?For example, can I get a list of all the advised indexes or is there an other way to optimize performance?Thanks a lotLuuk |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-26 : 06:39:08
|
First on your list should be making sure that the maintenance plans are set up properly. This would include updating statistics regularly and examining and rebuilding or reorganizing indexes as necessary.There are a few dmv's that can assist you in finding missing indexes - but use them with a grain of salt - you should use those just as a guidance or starting point to figure out what indexes you may need to add or remove. There is a brief article here, which you may find useful: http://weblogs.sqlteam.com/mladenp/archive/2009/04/08/SQL-Server---Find-missing-and-unused-indexes.aspx |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-26 : 06:48:36
|
In addition to the above, create Indexes based on most frequently fired queries. |
|
|
|
|
|