Archives: February 2011
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next major version of SQL Server) is called SQL Server AlwaysOn, which Microsoft describes like this:
The new SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize…
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level settings that you should consider changing from their default values. These include Max Server Memory, optimize for ad-hoc workloads, default backup compression, max degree of parallelism, and the number of…
Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14, which is Build 9.00.4317. The second one is SQL Server 2005 SP4 CU2, which is Build 9.00.5259. There are only two fixes for SP3 and nine fixes for… Read more
- Intel Xeon “Westmere-EX” support
- GPU frequency report on Intel Sandy Bridge processor
- AMD Zacate/Ontario processors support
- Report TDP on main page when available
- Cores clocks on floating…
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the popular CPU-Z utility on a Production database server. The questioner was concerned about possible instability or even a Blue Screen of Death (BSOD) that might occur if you ran CPU-Z… Read more
One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly understand the results that are returned. I have seen many people mix up the SQL Server portion of the results with the Operating System portion of the results.
Everything in… Read more
Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier today. They are using the Akamai Download Manager for these, and I was able to download them very quickly with no problems.
They also have slipstream installs that incorporate SP1… Read more
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be interested in (from a performance viewpoint) is the 2.5GHz twelve-core Opteron 6180 SE, which becomes the new top of the line Opteron processor, with a 200MHz speed bump over the… Read more
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL Server community and within Microsoft about whether and when you should enable this setting. Before you decide whether you want to do this, let me give you some background. When…
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM today in Colorado Springs. Here is the abstract:
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can…
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or newer, you can take advantage of this feature to dramatically
It will be available for download on MSDN and TechNet on February 16, and on Windows Update on February 22.
The two main new features… Read more
It is very nice to get some public recognition for your efforts, so I really appreciate this. It is hard to believe that I am… Read more
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!” which continues to get lots of hits three years later. I thought it was time to update this with a new version that you can download from here Read more