1 / 8

Monitoring and Optimizing SQL Server 2000

Monitoring and Optimizing SQL Server 2000. Palak Patel. Using Windows Performance. Features of Performance System Monitor Counter Logs Trace Logs Alerts Important Counters Processor  % Processor Time Memory  Pages/Sec Memory  Available Bytes Memory  Committed Bytes

ramla
Download Presentation

Monitoring and Optimizing SQL Server 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Monitoring and Optimizing SQL Server 2000 Palak Patel

  2. Using Windows Performance • Features of Performance • System Monitor • Counter Logs • Trace Logs • Alerts • Important Counters • Processor  % Processor Time • Memory  Pages/Sec • Memory  Available Bytes • Memory  Committed Bytes • Physical Disk  Average Disk Queue • Disk  % Disk Time • Network Segment  % Network Utilization

  3. Monitoring • Using Windows System Monitor • Using Alerts • Logging with Windows Counter Logs

  4. SQL Server Counters • SQL Server Buffer Manager  Cache Hit Ratio • SQL Server Buffer manager  Page Reads/Sec • SQL Server Buffer Manager  Page Writes/Sec • SQL Server General Statistics  User Connections • SQL Server Memory Manager  Total Server Memory (KB) • SQL Server SQL Statistics  SQL Compilations /sec

  5. SQL Query Analyzer • Setting up Current Connection Properties • Showing Execution Plan of a Query

  6. Monitoring with SQL Profiler • Setting up a Trace • Filtering trace data • Replaying the trace

  7. Index Tuning Wizard • Create Workload using Profiler • Run Index Tuning Wizard to get the suggestions on the Indexes with your database based on the typical workload

  8. Optimizing • Queries and Stored Procedures • Tempdb Size • Query Governor • RAID • Upgrade RAM • Manual Configuration of RAM • WITH RECOMPILE option to force SQL Server to recompile Stored Procedures • Proper Indexing • Defragmentation • DBCC SHOWCONFIG (Customers)

More Related