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

Content with tags SQL Server 7, Administration, Performance Tuning Rss

   Items 1 to 20 of 25    Older >>
 

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,729 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,158 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,558 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,815 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,722 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,729 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,558 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,158 reads

Importing And Analyzing Event Logs

Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!   Read more...
By Gheorghe Ciubuc 2003/05/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,779 reads

Economies of Speed Whitepaper

Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.   Read more...
By Additional Articles 2003/05/08 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,157 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,924 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

AWE Adventures

Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?   Read more...
By Joseph Sack 2003/04/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,728 reads

Identifying performance issues using Profiler

It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output.   Read more...
By Additional Articles 2003/04/01 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 2,465 reads

Squeezing Wasted Full Scans out of SQL Server Agent

This article by new contributing member Bob Musser shows you how to reduce the amount of scans that SQL Server Agent does against databases. Not for the faint of heart.   Read more...
By Bob Musser 2003/02/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,828 reads

How to Diagnose and Fix Wait Locks

This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.   Read more...
By Cathan Kirkwood 2002/11/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 32,355 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,797 reads

Sneak Preview: Start to Finish Guide to SQL Server Performance Monitor

Get a sneak peak of some of the sections from Start to Finish Guide to SQL Server Performance Monitor. Find out what counters to watch and what their thresholds are.   Read more...
By Brian Kelley 2002/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,223 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,815 reads

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.   Read more...
By Additional Articles 2002/03/08 | Source: Microsoft SQL Home | Category: administration
Rating:  Rate this |   Briefcase | 1,715 reads
   Items 1 to 20 of 25    Older >>
 
Tags
configuring (9)    
miscellaneous (7)    
t-sql (7)    
monitoring (3)    
backup / restore (2)    
distributed queries (2)    
indexing (2)    
programming (2)    
replication (2)    
stored procedures (2)    
strategies (2)    
advanced querying (1)    
analysis services (ssas) (1)    
data warehousing (1)    
database design (1)    
dts (1)    
english query (1)    
installation (1)    
naming standards (1)    
olap server (1)    
openxml (1)    
security (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)