March 6, 2009 at 11:13 am
Hi I want to use the SQL Index tuning wizard to help me make recommendations on my indexes. My question is, How much data should I sample with the SQL Profiler? Should I let it run for a few minutes or let it run for like an hour?
March 6, 2009 at 7:29 pm
The more data it you put into the system the longer it will take to return the results. Few caution steps about that tool:
1) Don't run it on production database, as it creates test statistics and don't always get cleaned up properly.
2) Don't run it on a production server; it will bog down the server.
3) All indexes and changes it gives you take them with grain of salt. They will def improve your read performance (at least in most cases I found); but the tool does not take into account updates/inserts.
So always evaluate the recommendations against what exists on database before making any changes. Another note for time frame it depends on how much activity is on server. The thing is you don't want to create indexes for statements that get run once only. So it is difficult to get accurate indexes recommendations...
Unless the query that you captured is known to be the issue...
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply