I have a sql2008R2 server with approximately 10 databases and 1400 stored procedures that will eventually support a website. I currently have 3 sql2008 machines doing the same in production. The goal of the new server is to remove all non-clustered
indexes and performance tune all the stored procedures using the sql tuning adviser and then compare the performance to what we have in production. I have been dragging my feet on this project as I dont really know where to start as many of the procs
exec other procs and access many database objects. I feel that there should be a specific order in how I start this project and I am looking for some advice from other users that may have had a similar project.
Thanks in advance.
View Complete Post