Wow… We have MAXDOP calculator for SQL Server… It makes my job easier…

So after Max. Server Memory calculator, to make your life much more easier, here is the Max Degree of Parallelism or MAXDOP calculator. We are using SQL DMV’s to find out the number of NUMA nodes and Powershell query to find out the number of processor cores and then use the recommendations given in http://support.microsoft.com/kb/2023536 to give a MAXDOP value…

11

Cool… Now we have a calculator for finding out a Max. Server Memory value

This calculator is now withdrawn since I’m not able to invest my time to improve it to make it “stay current”. Apologize for the inconvenience!   Hello SQL Community, I have written a simplified “Max. Server Memory” calculator for calculating “Max. Server Memory” value for 64-bit SQL Server instances after seeing my blog referenced in MSDN forums,…

4

SQL Server 2012 Upgrade Technical Guide & What’s new Whitepaper Released

SQL Server team has published the “SQL Server 2012 Upgrade Technical Guide” at http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf I encourage you to upgrade to SQL Server 2012 using this guide (HOW TO UPGRADE), What’s New whitepaper (WHY UPGRADE) downloadable from http://download.microsoft.com/download/E/9/D/E9DBB1BB-89AE-4C70-AF02-AAFC29451A85/SQL_Server_2012_Whats_New_White_Paper.pdf and other resources in the web site http://www.microsoft.com/sqlserver/en/us/product-info/why-sql-server.aspx  

5

INF:What happens to a database when transaction rollback fails?

Today while working on a SQL Server performance case, I was asked this question “What happens to a database when transaction rollback fails?”. I thought of sharing the answer to the community so that it can help DBA’s to understand how SQL Server handles this scenario. So what happens when a transaction rollback fails? Database…

1

"Failed to save Local Policy Database" while granting any privilege to SQL Service SID in Group Policy Editor

When you try to grant any privilege to SQL Server Service SID using Group Policy Editor in Windows 2008, you might get this error: An extended error has occurred.Failed to save Local Policy Database. This happens only when you try to add virtual accounts like NT SERVICE\MSSQLSERVER NT SERVICE\SQLSERVERAGENT to grant certain privileges like Act…

0