Monitoring load on capacity of the SQL server 1856 https://lepide.com
Close
Login to Your Account
+ Reply to Thread
Results 1 to 8 of 8

Thread: Monitoring load on capacity of the SQL server

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    4

    Monitoring load on capacity of the SQL server

    Hi,

    How to monitor the capacity load of an SQL server? Is this possible with native SQL server Management, I am specifically interested in finding out how database is slowing down and causing poor performance of SQL server.

    Thanks

  2. #2
    Hi JohnMat

    You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000.
    These counters allow you to view or save information about the overall performance of your server.
    When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed.
    You must have administrative access to your SQL Server to use these objects, SQL Server Admins should find them invaluable in monitoring and tuning the database server.

    To open the Performance monitor in Win2K, go to Start | Programs | Administrative Tools | Performance. When viewing your performance data in real time, you can view it as a report, a chart, or a histogram

    Name:  sw_perf_monitor_image001.jpg
Views: 444
Size:  16.1 KB

  3. #3
    Junior Member
    Join Date
    Jan 2013
    Posts
    4
    Thanks Pankaj

    Can we monitor what is actually causing our SQL server performance how can we limit on that

    thanks

    john

  4. #4
    DBA responsible for maintaining SQL server and its database but, as the volume of data has grown and the load on the server increased, the queries have
    grown slower and deadlocks have become a frequent occurrence.
    so these are some main points that may responsible for performance degradation in SQL Server

    1. Retrieving too much data.
    2. Misuse of transactions.
    3. Misuse of indexes.
    4. Mixing OLTP, OLAP, and reporting workloads.
    5. Inefficient Index
    6. Join operations or inefficient join operations
    7. Using an inefficient disk subsystem.

  5. #5
    Junior Member
    Join Date
    Jan 2013
    Posts
    4
    Great info

    So how can be overcome these issues ??

  6. #6
    Thanks john

    ....Storing data non-contiguously on disk and having many truncation in your database, resulted your database has occur fragmentation.
    In other word we can say your database performance is decrease to avoid this you should perform these operations

    1.Defragmentation
    2. Rebuilding the indexes
    3. Reorganising the indexes
    4. Shrink Database (If needed)
    5. Partition Table/Indexes
    6. Reallocate page in logical order by heap method

    Pankaj

  7. #7
    Junior Member
    Join Date
    Jan 2013
    Posts
    4
    Many Thanks

    for clearing my doubts about performance threads in SQL server

  8. #8
    glad to help !
    freely ask SQL related questions here
    we are here to help you round the clock

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

Lepide® is a registered trademark of Lepide Software Private Limited. © Copyright 2018 Lepide Software Private Limited. All trademarks acknowledged.