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

Content with tags Performance Tuning, Configuring Rss

   Items 1 to 16 of 16   
 

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,814 reads

Managing Max Degree of Parallelism

Herve has done some work experimenting with max degree of parallelism (DOP) on some large multi processor blocks and based on that, has some recommendations for you if you're using more than 8 processors. Good reading!   Read more...
By Herve Roggero 2003/06/23 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 30,105 reads

Is Windows 2003 Really Faster?

Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.   Read more...
By Brian Knight 2003/06/10 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 12,865 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,923 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

Query Recompilation in SQL Server 2000

Recompilation yields superior performance in some situations, although excessive recompilation can be detrimental. This article will discuss some of these costs and benefits, and will draw on contrasts between different versions of SQL Server to provide further context for understanding recompilation.   Read more...
By Additional Articles 2002/06/07 | Source: MSDN Communities | Category: configuring
Rating:  Rate this |   Briefcase | 990 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,814 reads

Improving Text and Image Column Performance

This article is a case study of a performance problem at SQLServerCentral.com with our FAQ area using text columns. This will show you how to use the TEXT IN ROW feature built into SQL Server 2000 to improve the performance of these columns.   Read more...
By Brian Knight 2002/04/01 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 6,301 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,714 reads

Speed of Partitioned Views

There has been some talk about the use of partitioned views in SQL Server 2000 to gain performance improvements for scale-out of applications. In this article by Neil Jacobson, he discusses his findings in respect of the speed of partitioned views.   Read more...
By Neil Jacobson 2002/02/13 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 6,759 reads

How to Setup Log Shipping with SQL 2000

This white paper outlines the following: -The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition. -The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition. -A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.   Read more...
By Additional Articles 2002/01/25 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 1,502 reads

Microsoft SQL Server 2000 Scalability Project

This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware.   Read more...
By Additional Articles 2002/01/10 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 992 reads

INF: Understanding How to Configure a SQL Server Connection Affinity

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.   Read more...
By Additional Articles 2001/08/28 | Source: ASPToday | Category: administration
Rating:  Rate this |   Briefcase | 1,180 reads

Tuning SQL Server Memory in 2 Minutes

You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.   Read more...
By Neil Boyle 2001/05/21 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 9,830 reads
   Items 1 to 16 of 16   
 
Tags
sql server 7 (15)    
administration (9)    
miscellaneous (6)    
t-sql (3)    
distributed queries (2)    
indexing (2)    
installation (2)    
monitoring (2)    
replication (2)    
backup / restore (1)    
dts (1)    
english query (1)    
news (1)    
openxml (1)    
programming (1)    
security (1)    
stored procedures (1)    
strategies (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)