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

Content with tags Performance Tuning, Miscellaneous Rss

<< Newer    Items 21 to 25 of 25   
 

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

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,235 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,508 reads

Profiler - Logging Results to a Table

SQL Profiler lets you log the results of a trace directly to a table, yet would you believe you can't save the trace as a script to do the exact same thing? Find out why and get some ideas on work arounds.   Read more...
By Andy Warren 2002/01/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,469 reads

Taming the Stateless Beast: Managing Session State

Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.   Read more...
By Additional Articles 2001/07/06 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,277 reads
<< Newer    Items 21 to 25 of 25   
 
Tags
sql server 7 (19)    
t-sql (13)    
programming (10)    
administration (7)    
configuring (6)    
indexing (4)    
strategies (4)    
ado (3)    
monitoring (3)    
stored procedures (3)    
visual basic 6 (3)    
xml (3)    
backup / restore (2)    
basics (2)    
distributed queries (2)    
openxml (2)    
replication (2)    
security (2)    
analysis services (ssas) (1)    
asp (1)    
data warehousing (1)    
database design (1)    
dts (1)    
english query (1)    
installation (1)    
olap server (1)    
sql puzzles (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xsl (1)