Microsoft Blog Images
Browse by Tags
Search this blog
Search all blogs
Email Blog Author
RSS for posts
RSS for comments
Tagged Content List
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 usi ng 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...
23 May 2012
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...
18 May 2012
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 on...
11 Apr 2012
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...
6 Jul 2011
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...
8 May 2011
Page 1 of 1 (5 items)
© 2015 Microsoft Corporation.
Privacy & Cookies