Browse by Tags

• activity
• analysis
• api
• application
• arithabort
• backups
• best practice
• blocking
• blog
• busy
• cache
• columns
• compiled
• create
• creation
• cursor
• databases
• dmv
• heavy
• i/o
• indexes
• monitoring
• online
• operating system
• perfmon
• performance
• poor
• statistics
• stored procedure
• sysmon
• table
• tuning
• usage
• users

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 January 08 02:41 AM | SQL Master | 3 Comments   

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, Read More...

Filed under: performance, sql server, cache, indexes, tsql, users, best practice, backups, monitoring, operating system, creation, create, online, busy

How to monitor transaction activity between the databases?
10 January 08 03:23 AM | SQL Master | 2 Comments   

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more Read More...

Filed under: sql server, dmv, databases, tsql, statistics, i/o, activity

SQL Server 2005: Slow running queries - Blocking and Index problems
24 September 07 07:19 AM | SQL Master | 2 Comments   

As a DBA you must be aware that slow or long running queries can contribute to excessive resource consumption and be the consequence of blocked queries. No database application is exception to this behaviour, so the queries that also run slowly because Read More...

Filed under: tsql, poor, sql server, dmv, blocking, indexes, blog

TSQL cursors vs API cursors - poor cursor usage
27 August 07 06:54 AM | SQL Master | 2 Comments   

Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning Read More...

Filed under: performance, sql server, usage, cursor, application, tsql, api, heavy

How to Analyze the PERFMON (SYSMON) data?
20 August 07 11:26 AM | SQL Master | 2 Comments   

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data Read More...

Filed under: tuning, performance, sql server, perfmon, databases, sysmon, tsql, analysis

How do I find all the statistics and statistics columns on a specified object?
16 July 07 05:46 AM | SQL Master | 1 Comments   

USE <database_name>; GO SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id INNER JOIN sys.columns AS c ON Read More...

Filed under: performance, sql server, indexes, table, tsql, statistics, columns

Conditional Failed because the followng SET operations has incorrect settings: 'ARITHABORT'
16 July 07 01:10 AM | SQL Master | 1 Comments   

I got this error when trying to drop and create an index on a table. Create failed for index IX_USER_ID (Microsoft.SQLServer.Smo) Additional Information An exception occured while executing a transact sql statement or batch (Microsoft.SQLServer.ConnectionInfo) Read More...

Filed under: sql server, indexes, stored procedure, compiled, tsql, arithabort