Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Performance Tuning, Administration Rss

<< Newer    Items 21 to 40 of 61    Older >>
 

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...
Rating: |  Discuss |   Briefcase | 5,677 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,054 reads

The Ultimate Duplicate Index Finder

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,962 reads

Can you shrink your SQL Server database to death?

To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.  Read more...
By Additional Articles 2008/10/14 | Source: SearchSQLServer | Category: administration
Rating:  Rate this |   Briefcase | 3,887 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,434 reads

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,405 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,558 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,469 reads

Indexing in SQL Server 2005

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.   Read more...
By Aaron Ingold 2007/01/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,553 reads

Moving the tempdb database

Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.  Read more...
By Additional Articles 2007/12/06 | Source: SQLTeam.com | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,189 reads

Update SQL Server Table Statistics for a Performance Kick

Find out how to update and tune table statistics in SQL Server to ensure data accuracy and boost performance. Learn auto and manual update commands.  Read more...
By Additional Articles 2007/11/09 | Source: SearchSQLServer | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,049 reads

Optimize tempdb in SQL Server by Striping and Splitting

Find pointers to optimize tempdb performance in SQL Server by striping and splitting across multiple files in SQL Server 2005.   Read more...
By Additional Articles 2007/11/07 | Source: SearchSQLServer | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,388 reads

BULK recovery mode and DBCC DBREINDEX

Will changing to bulk recovery mode before running DBCC REINDEX help you avoid large log files? András investigates  Read more...
By Additional Articles 2007/10/02 | Source: SimpleTalk | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,088 reads

Indexing in SQL Server 2005

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.   Read more...
By Aaron Ingold 2007/01/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,553 reads

Fine Tuning your Database Design in SQL 2005

Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005  Read more...
By Additional Articles 2006/10/17 | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 3,380 reads

Checking Your Database Fragmentation Level

Fragmentation in SQL Server is a huge debate. Does it matter? How much is too much? What should you do? In any case, new author Nicholas Cain has put together a system that allows him to keep track of the levels of fragmentation as well as defragment those tables when he feels they are getting too spread apart.   Read more...
By Nicholas Cain 2005/11/18 (first published: 2004/06/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,720 reads

Performance Monitoring - Basic Counters

What counters should you monitor to baseline your servers? Which ones for checking performance? It's an interesting question and one that always leads Steve Jones to a wide range of sources in print and on the web. Steve compiled his own list and finally has put some words around the list to give some justification of why they are chosen. Read on and see how this compares to your list (you do have a list don't you?).   Read more...
By Steve Jones 2005/11/11 (first published: 2004/05/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,121 reads

Execution Plans

How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.   Read more...
By Gulappa Vijaya Kumar 2005/10/07 (first published: 2004/05/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 51,524 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,812 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,701 reads
<< Newer    Items 21 to 40 of 61    Older >>
 
Tags
sql server 7 (20)    
t-sql (18)    
indexing (13)    
sql server 2005 (13)    
utility (11)    
maintenance (10)    
maintenance and management (10)    
configuring (9)    
miscellaneous (7)    
list indexes (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
crosstab (4)    
for xml path (4)    
monitoring (3)    
backup / restore (2)    
distributed queries (2)    
lock and connection management (2)    
programming (2)    
replication (2)    
stored procedures (2)    
strategies (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
troubleshooting (2)    
tuning (2)    
advanced querying (1)    
analysis services (ssas) (1)    
data warehousing (1)    
database design (1)    
dts (1)    
duplicate indexes (1)    
english query (1)    
foreign keys (fk) (1)    
heap (1)    
installation (1)    
missing indexes (1)    
naming standards (1)    
olap server (1)    
openxml (1)    
row compression (1)    
search (1)    
security (1)    
selectivity (1)    
shrink database (1)    
sql server 6.5 (1)    
sqlservercentral (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
table compression (1)    
tables (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
vmware (1)    
xml (1)    
xsl (1)