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

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 9 2010
Filed under: Filed under: sql server, memory, dmv, dba, cpu, best practice, sql server 2008 r2, database user, server scope, sys.dm_os_
SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 24 2010
Filed under: Filed under: sql server, memory, technet, security, query, cache, BOL, best practice, configuration, plan guide, benchmarking
SQL Server 2008 Cumulative Update 2 for SP1 - support the concept of Locked Pages for Standard Edition

During the keynote session of European PASS 2009 Bob Ward from Microsoft CSS team has announced about standard SKU for SQL Server 2005 and 2008 version to enable 'Locked Pages in Memory' privilege that will allow the hardware resources to use...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 25 2009
Filed under: Filed under: sql server, memory, buffer, standard, best practice, 64 bit, cumulative update, editions, pool memory, locked pages, reduce paging
SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 4 2008
Filed under: Filed under: sql server, memory, maintenance plan, i/o, clustered, best practice, monitoring, resources, configuration, performance monitoring, contention
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues

Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 1 2008
Filed under: Filed under: sql server, performance, memory, cache, disk space, troubleshoot, system, best practice, raid, hardware, monitoring, configuration, baseline
SQL Server 2008 Resource Governor FAQ

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 25 2008
Filed under: Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor
SQL Server 2005 memory configuration gotchas

This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Dec 28 2007
Filed under: Filed under: sql server, performance, memory, security, applications, best practice, awe, pae, dynamic, 3gb, benchmarking, performance monitoring, settings

Page 1 of 1 (7 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.