February 27, 2013 at 8:52 am
Hi Everyone,
Hope your all having a good day 🙂 I was just doing some index and statistic research and was wondering if anyone had any useful tips or queries for checking to see if my indexes applied are doing their job? I find many people saying when a query is slow that applying a new index using the query tuner isnt always a good idea but they never seem to say what should be done instead :ermm: Could anyone tell me what their schedule is for keeping on top of things?
Thanks in advance all,
Regards,
Craig
February 27, 2013 at 10:12 am
Basically this on a weekly, bi-weekly or monthly basis.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2013 at 10:22 am
Thanks GilaMonster!
Thats exactly what I was looking for 😀 hope you have a nice evening,
Regards,
Craig
February 27, 2013 at 10:26 am
Great articles Gail linked to. I'd tend to do this monthly, but YMMV.
February 27, 2013 at 10:42 am
Hi Steve,
I'm just reading over them now and they are absolute gold :Wow: It will definately become part of maintenance schedule 🙂 I cant thank her enough 🙂 your in a league of your own Gail 😉
Kindest Regards,
Craig
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply