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

Restore database stuck at 90% waiting on PREEMPTIVE_OS_WRITEFILEGATHER

There are already few blogs and a KB to talk about this problem so I’m trying to tie them together to make sure you get this quickly When you are restoring a database (in my case a database having 32 files), post 90% complete, all but one threads in sysprocesses went into SUSPENDED state waiting…

1

Error: 18056 State: 29 The client was unable to reuse a session. The failure ID is 29 after upgrading SQL 2000 to SQL 2008 SP2

I want to share this troubleshooting scenario since it may help you: After upgrading SQL Server 2000 SP4 to SQL Server 2008 SP2, SQL Server experienced performance problems and many a times, connection failures SQL Server errorlog shows this message during the problem period: Error: 18056, Severity: 20, State: 29. The client was unable to…

2

Best Performer: Distributed query (Four-part) or OPENQUERY when executing linked server queries in SQL Server

I wanted to share this information to all those who are searching for better performer when it comes to distributed query vs openquery for running linked server queries. Distributed Query : Linked server four part queries are also called distributed queries. Using distributed queries,  you can refer tables on different data sources/servers in a single…

6