Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)

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

Posted Tuesday, April 21, 2009 10:13 AM by spawar
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 Read More...
0 Comments

SQL Server I/O for Thought

Posted Wednesday, April 15, 2009 9:24 AM by spawar
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 Read More...
0 Comments

SQL Server CACHING & Performance Testing

Posted Friday, January 09, 2009 4:40 PM by spawar
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 Read More...
0 Comments
 
Page view tracker