Web Development

Ask something
Discussion Locked

Performance Tunning

0 helpful
6 replies

by mo_hdnadeem

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have 4 Windows2000 Server out which i have one Database Server with SQL Server2000
Can anybody help me how to do Performance Tunning for SQL server2000, and Network Monitoring etc.. in SQL (Please Write the Procedure in Steps)

Thanks & Regards

Nadeem.

6 replies

by maxwell edison

SQL Server Performance Tuning:
The definitive guide to SQL Server Performance Optimization. A free ebook hosted by Precise and written by industry expert Don Jones, this eBook will look provide guidance and examples to illustrate the different performance optimization tactics for SQL Server. Topics will include: Understanding Performance Components and Scaling Concepts, SQL Server Performance Audit Methodology, Measuring Performance, Core Server Performance Tuning Techniques, Basic to Advanced Query Performance Tuning, Scaling SQL Server for Performance, and Improving Performance from the Client Side

How to Do SQL Server Performance Trend Analysis:
Part 1: Using Performance Monitor to Log Data
This is the first part of a four-part article on how to perform SQL Server Performance Trend Analysis. This part focuses on how to best log data using Performance Monitor. Source: SQL-Server-Performance.com

How to Do SQL Server Performance Trend Analysis
Part 2:
Importing Log Data into SQL Server
This is the second part of a four-part article on how to perform SQL Server Performance Trend Analysis. It shows you how you can optionally import the Performance Monitor data into SQL Server as a means of storing and retrieving it as needed for analysis. Source: SQL-Server-Performance.com

How to Do SQL Server Performance Trend Analysis Part 3:
Trend Analysis Using Microsoft Excel
This is the third part of a four-part article on how to perform SQL Server Performance Trend Analysis. It shows you how to import Performance Monitor data into Microsoft Excel for Trend Analysis. Source: SQL-Server-Performance.com

How to Do SQL Server Performance Trend Analysis
Part 4:
Interpreting Performance Counters
This is the last part of a four-part article on how to perform SQL Server Performance Trend Analysis. It shows you how to interpret Performance Monitor counters. Source: SQL-Server-Performance.com

(continued...)

by maxwell edison

Improving Performance with SQL Server 2000 Indexed Views:
With SQL Server 2000, the functionality of views has been expanded to provide system performance benefits. It is now possible to create a unique clustered index, as well as nonclustered indexes, on a view, to improve data access performance on the most complex queries. Source: Microsoft.com

Index Tuning Wizard for SQL Server 2000:
Read this MSDN article to learn how the Index Tuning Wizard in SQL Server 2000 simplifies the task of identifying which indexes to create in a table. Source: Microsoft.com

Monitor Your SQL Servers with SQL Power Tools:
Learn how to better monitor your SQL Servers from this review of SQL Power Tools. Source: SQL-Server-Performance.com

Optimizing SQL Server Performance:
Unlike with SQL Server 6.x, in SQL Server 7.x and 2000, databases reside on operating-system files. Alexander Chigrik's latest article offers some file and filegroup optimization tips when using databases with the newer versions of SQL Server. Source: Swynk.com

Save Space To Boost SQL Server Performance:
A few simple space saving techniques can speed up your SQL Server databases. Source: SQL-Server-Performance.com

SQL Server Performance Tuning Guides:
Optimize response time for each query by minimizing network traffic, disk I/O, and CPU time for maximum processing throughput. Source: Microsoft.com

SQL Server 2000 Performance Tuning Tools:
An introduction to the key tools included with SQL Server 2000 to help you performance tune your SQL Server applications. Source: SQL-Server-Performance.com

(continued...)

by maxwell edison

Support WebCast - How to Collect and Analyze Performance Data in Microsoft SQL Server:
During this session, we will discuss the tools used to collect performance data and how to use this data to analyze some common SQL Server performance issues. We will review how to set up these tools and analyze the data collected. In addition, we will talk about troubleshooting techniques used to identify SQL Server performance issues

Support WebCast: Microsoft SQL Server - Rapid Blocker Script Analysis:
During this session, we will show a practical approach to analyze performance tuning problems that involve Microsoft SQL Server lock monitoring data. We will briefly discuss sp_who2, sysprocesses, and syslocks

Transactional Replication Performance Tuning and Optimization:
Find out how to improve your transactional replication implementation to optimize performance. Source: Microsoft.com

Upgrade to SQL Server 2000 SP1 for Improved Performance:
Upgrading to SP1 can provide some performance boosts for SQL Server 2000. Source: SQL-Server-Performance.com

This discussion is closed to new replies.