Browse Blog Posts by Tags

All Tags » sql server » benchmarking (RSS)

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 Performance series: Trace Flag 845 and Lock Pages in Memory

A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 25 2011
Filed under: Filed under: sql server, security, version, best practices, configuration, cumulative update, benchmarking, performance monitoring, lock down, lock pages in memory
Analysis Services database and OLAP systems: building and tuning for the best possible performance

When it comes to performance tuning there is no magic wand or short cut to wipe out the issue. The process is a constant learning and primary step is to ensure no issues are occuring repeatedly, which means you are not utilizing the time to reduce the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 17 2011
Filed under: Filed under: sql server, performance, analysis, best practices, monitoring, cube, benchmarking, performance tuning, performance guide, scalable
SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

SQL Server Integration Services (SSIS) is an important service that is required to continue the ETL (extract transform load) tasks on your data platform. You may notice that since SQL Server 2005 version onwards the database maintenance plans will always...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 11 2011
Filed under: Filed under: sql server, ssis, security, best practices, error log, integration services, benchmarking, component services
SQL Server BI Performance series: managing CUBE performance issues

What kind of performance issues you will need to face when you are setting/managing a Business Intelligence environment involving SQL Server technologies. I see this more as a practical question than to answer about the technology. When we talk about...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 13 2011
Filed under: Filed under: sql server, ssis, ssas, ssrs, dba, query, best practices, business intelligence, benchmarking, ebook, parallel processing
SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb

The global resource for a SQL Server system is TEMPDB, because it holds all the information pertaining to temporary user objects, internal objects used by SQL engine, row versioning for data modifications and any ad hoc TSQL execution results. Since SQL...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jun 8 2011
Filed under: Filed under: sql server, perfmon, performance, dba, best practices, table, troubleshoot, tempdb, monitoring, benchmarking, performance monitoring, counters
SQL Server optimization series - query recompilation gotchas

What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 5 2011
Filed under: Filed under: sql server, performance, optimization, best practices, stored procedure, query plan, recompile, benchmarking, statiscs age
SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Mar 25 2011
Filed under: Filed under: sql server, performance, memory, dba, attributes, best practices, dimension, cpu, wizard, cube, benchmarking, diagnose
SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?

TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 15 2011
Filed under: Filed under: sql server, best practices, storage, system, tempdb, tsql, extent, benchmarking, performance monitoring, contention, dmvs
SQL Server Perf: What is the optimal disk or data file placement configuration layout for better performance?

SQL Server manages when and how disk I/O is performed, but the Windows operating system performs the underlying I/O operations. The I/O subsystem includes the system bus, disk controller cards, disks, tape drives, CD-ROM drive, and many other I/O devices...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 29 2010
Filed under: Filed under: sql server, dba, disk, best practices, storage, tempdb, cpu, raid, benchmarking, core, alignment
SQL Server do not use PROFILER, use Server side trace to upload to table!

As a followup questions from the post SQL Server Profiler: System is low on disk space on drive 'C'? here I had a feedback of how to save the server-side trace to a table? Well there is no direct path to do so, rather a roundabout method of once...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 6 2010
Filed under: Filed under: sql server, trace, dba, xml, best practices, disk space, table, benchmarking, server side
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
SQL Server SSIS package performance series - resolve the low-memory conditions

SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Apr 21 2010
Filed under: Filed under: sql server, package, perfmon, performance, ssis, ssas, access, best practices, benchmarking, low memory
SQL Server Manageability - Choose Analysis Services database backup strategy

Until SQL Server 2005 performing a backup of Analysis Services database was a troublesome, not like DB engine database backup statements. As said above 2005 version onwards the backup and restore operations are an integral part of the Analysis Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 2 2010
Filed under: Filed under: sql server, performance, databases, backup, best practices, Analysis Services, command line, rolap, molap, holap, benchmarking, aso
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 performance problem, how bad it is or rather I ask how good are you to find the root cause?

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 27 2009
Filed under: Filed under: sql server, perfmon, performance, ssms, tools, best practices, encryption, locks, baseline, benchmarking, performance monitoring
SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 15 2008
Filed under: Filed under: sql server, performance, dmv, best practices, tempdb, monitoring, benchmarking, performance monitoring
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 29 2008
Filed under: Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking
SQL Server Analysis Services MDX Query performance monitoring - highlights

When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 29 2008
Filed under: Filed under: sql server, performance, mdx, query, best practices, tsql, monitoring, Analysis Services, baseline, benchmarking
Best way to deploy SQL Server 2005 with SAN

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 28 2008
Filed under: Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio
Is RAID5 better for performance when SQL Server Clustering and SAN is involved?

One of the recent usergroup meeting brought an interesting question that "what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster"? By default RAID5 hardware controller is best to hold as not to go with software RAID5 as...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 23 2008
Filed under: Filed under: sql server, performance, san, best practice, hardware, disks, monitoring, benchmarking, scsi

Page 1 of 2 (23 items) 1 2 Next >

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.