Browse by Tags

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.

Published 6 October 8 4:51 AM | SqlServer-QA.net

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself...

Filed under: sql server, performance, query, optimization, best practices, hints, knowledge, performance monitoring, engine

SQL Server Performance - consideration on unique index or filtered index.

Published 25 September 8 2:46 AM | SqlServer-QA.net

It is no doubt that when a database consists ' well-designed ' indexes can reduce disk I/O operations and consume fewer system resources therefore improving query performance. You might be wondering I'm going back to basics for indexes! So...

Filed under: sql server, performance, indexes, optimization, indexed view, statiscs age, filtered, dml

New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Published 2 January 8 6:36 AM | SSQA.net

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat

Considering Parallel plans and forcing plans for better performance

Published 23 October 7 8:55 AM | SSQA.net

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...

Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force

Disk Space Requirements for Index DDL Operations

Published 28 September 7 8:38 AM | SSQA.net

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...

Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing

XLOCK Hint is ignored even though specifying explictly?

Published 11 September 7 5:21 AM | SSQA.net

Interesting newbie question on the forums to share. I am selecting a value from a table(column).I do not want any 2 users can select same value at the same time..in other word 1 value only be selected by individual user. in order to do it I am simply...

Filed under: sql server, performance, optimization, hints, statistics, locking, results, xlock

FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

Published 2 August 7 9:17 AM | SSQA.net

There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may...

Filed under: performance, backup, optimization, disk space, full-text

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics

Get statistics on Query plan optimizer execution

Published 11 May 7 4:48 AM | SqlServer-QA.net (SSQA)

As you might know PERFMON (SYSMON) and DMVs in SQL 2005 are very handy to know internal resource information about the SQL Server engine. So you might be thinking what might be the cause of this poor performance when you have a simple query to run and...

Filed under: sql server, stats, security, query, optimization, perfmance, reporting