Briefing: Mission Critical Confidence in the Enterprise

  High availability, manageability, performance, scalability, security and compliance – a heavy  set of requirements for meeting the needs of a mission critical workload.  SQL Server 2012 is setting the new standard for these criteria —helping customers achieve the uptime and performance they need at a low Total Cost of Ownership (TCO), backed by built-in…

3

Say good bye to performance issues in SQL Server 2008 with the aid of this whitepaper…

A new white paper on SQL Server 2008 performance troubleshooting is now available and linked from our Technical Articles node in the MSDN Library. This paper is about 100 pages and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O Bottlenecks Slow-Running Queries Extended Events Data Collector and the MDW You can find the…

1

SQL Server I/O for Thought

Following are the links specifically relating to best practices for setting up disk I/O for SQL Server workloads. Predeployment I/O Best Practices – http://sqlcat.com/whitepapers/archive/2007/11/21/predeployment-i-o-best-practices.aspx Complete I/O Best practices whitepaper – http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx Storage Top 10 Best Practices – http://sqlcat.com/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx Tools – below are links to tools that can aid you in the testing of I/O for…

0

SQL Server CACHING & Performance Testing

As you know SQL Server uses caches to speed up access to data and also query plans.   There are two caches one for Data and the other of Query Plans. When you are doing performance testing, with static data and you want to get accurate results of your test, it is recommended that you…

0