Browse by Tags

All Tags » performance » indexes   (RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
How to gain Disk related performance with few simple steps
30 July 07 07:24 AM | SQL Master | 4 Comments   
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write Read More...
Unused indexes on a database, its good and bad
27 July 07 06:51 AM | SQL Master | 3 Comments   
You may be aware that the indexes on a SQL Server database take up space, so in case of unused indexes its obvious that they waste storage. It is easy to find the indexes using SP_HELPINDEX statement against a table, so to identify the unused indexes Read More...
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...
Index fragmentation and DBCC SHOWCONTIG in SQL Server 2005!
03 July 07 02:55 AM | SQL Master | 0 Comments   
In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem. Read More...
More Posts Next page »

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication