Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 24 2010
Filed under: Filed under: sql server, performance, dba, query, best practice, parallel execution, max worker threads, numa, benchmarking, performance monitoring, latches, maxdop, threads
Improve Performance on query execution - control Parameter Sniffing

Going back to basics 'parameter sniffing' is a process where SQL Optimizer helps (sniffs) the execution process any current parameter values during compilation or reccompilation process. It will attain a pass-along values to the query optimizer...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Mar 22 2010
Filed under: Filed under: sql server, profiler, performance, query, monitor, kba, maintenance, parallel execution
SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 18 2008
Filed under: Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability
Considering Parallel plans and forcing plans for better performance

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 23 2007
Filed under: Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force

Page 1 of 1 (4 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

Improve Performance on query execution - control Parameter Sniffing

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Considering Parallel plans and forcing plans for better performance