Browse by Tags

• alter index
• arithabort
• backup
• backups
• best practice
• blocking
• blog
• blogs
• bulk insert
• busy
• cache
• clustered
• columns
• compiled
• cpu
• create
• creation
• dashboard
• databases
• dba
• dbcc shrinkfile
• disable
• disk
• disk space
• disks
• dml
• dmv
• etl
• fillfactor
• filtered
• guid
• hardware
• high cpu
• hotfix
• huge
• included
• index plan
• indexed view
• indexed views
• integration
• IO
• kalen delaney
• kba
• links
• load
• maintenance plan
• management
• measures
• memory
• microsoft
• missing
• monitor
• monitoring
• msdn
• object
• online
• operating system
• optimization
• overhead
• package
• performance
• performance monitoring
• plan
• plan guide
• planning
• poor
• query
• raid
• rebuild
• recompile
• reindexing
• reorganize
• schedule
• schema
• script
• security
• service pack
• services
• slow query
• sorting
• sp_help
• sp_helpindex
• sql queen
• statiscs age
• statistics
• stored procedure
• sys.dm_db_index_physical_stats
• table
• testing
• too many
• tool
• tsql
• uniquire
• unused indexes
• update statistics
• users
• view

SQL Server Performance - consideration on unique index or filtered index.
25 September 08 12:46 AM | satyaskj | 2 Comments   

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 when the database Read More...

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

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...

Filed under: sql server, cache, memory, indexes, databases, cpu, monitoring, operating system, huge, dbcc shrinkfile

SQL Server 2005 DMV - how it can help to consider whether index is useful or not?
04 February 08 07:06 AM | SQL Master | 4 Comments   

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views Read More...

Filed under: performance, sql server, dmv, indexes, dba, performance monitoring, index plan

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: sql server, cache, indexes, tsql, users, best practice, backups, monitoring, operating system, creation, create, online, busy, performance

SQL Server indexing - when to reorganize or rebuild?
21 January 08 03:30 AM | SQL Master | 4 Comments   

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts Read More...

Filed under: sql server, indexes, msdn, rebuild, schema, best practice, blogs, performance monitoring, reorganize, links, schedule

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV
14 January 08 01:22 AM | SQL Master | 2 Comments   

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA Read More...

Filed under: performance, sql server, dmv, indexes, dba, best practice, maintenance plan, performance monitoring, sys.dm_db_index_physical_stats, measures

SQL Server SP_HELPINDEX - updated version that includes column names
03 January 08 12:46 PM | SQL Master | 2 Comments   

Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA Read More...

Filed under: sql server, indexes, databases, script, columns, sql queen, sp_helpindex, kalen delaney, included, sp_help

SQL Server ETL Performance during Data Load Optimization
20 December 07 07:40 AM | SQL Master | 2 Comments   

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL Read More...

Filed under: performance, sql server, indexes, backup, disable, slow query, bulk insert, load, etl, alter index

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
30 October 07 08:41 PM | SQL Master | 2 Comments   

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results Read More...

Filed under: performance, sql server, indexes, planning, testing, hotfix, services, best practice, service pack, plan guide

Stored Procedures caught me with too many recomplies - way out to avoid it
25 October 07 01:35 AM | SQL Master | 2 Comments   

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still Read More...

Filed under: performance, sql server, indexes, kba, recompile, stored procedure, high cpu, blogs, too many

Update Statistics on huge tables - best practice
23 October 07 04:40 AM | SQL Master | 2 Comments   

If you have valid indexes and they are maintained with regular schedule of reindexing to address fragmentation, then you can go with UPDATE STATISTICS on the tables that has frequent updates, say once in 2 days during the quiet time on the databases. Read More...

Filed under: performance, sql server, indexes, update statistics, best practice, indexed views

Guidelines for enabling indexes and online index operations
08 October 07 06:50 AM | SQL Master | 4 Comments   

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and Read More...

Filed under: performance, sql server, management, indexes, databases, dashboard, indexed view, monitoring

Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   

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

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

Performance consideration or overhead having primary key with 3 GUID (Clustered Index)
25 September 07 02:17 PM | SQL Master | 2 Comments   

During a database design there has been an interesting discussion that will there be any performance addition in adding a second non-clustered index on a Globally Unique ID ( GUID ) column that has already a unique clustered index. IF needed you need Read More...

Filed under: performance, sql server, indexes, clustered, view, overhead, uniquire, guid

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: sql server, dmv, blocking, indexes, blog, tsql, poor