Browse by Tags

• best practice
• consolidation
• hotfix
• indexes
• instances
• management
• multiple
• performance
• plan guide
• service pack
• services
• sql server
• testing

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
30 October 07 08:41 PM | SQL Master | 2 Comments   

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results Read More...

Filed under: performance, sql server, indexes, planning, testing, hotfix, services, best practice, service pack, plan guide

SQL Server consolidation & keeping up performance at the same time
15 June 07 02:03 AM | SQL Master | 1 Comments   

So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc. No doubt that Read More...

Filed under: performance, sql server, management, multiple, instances, planning, consolidation