Monitoring load on capacity of the SQL server - Reply to Topic
See How We Help you Protect your Data, Detect and React to Threats Watch Now
Login to Your Account
Untitled Document

Reply to Thread

Post a reply to the thread: Monitoring load on capacity of the SQL server

Your Message

Click here to log in

What is the latest version of LepideAuditor we launched? (like: 15.2)


You may choose an icon for your message from this list

Additional Options

Topic Review (Newest First)

  • 02-11-2013, 09:31 AM
    glad to help !
    freely ask SQL related questions here
    we are here to help you round the clock
  • 01-31-2013, 09:47 AM
    Many Thanks

    for clearing my doubts about performance threads in SQL server
  • 01-30-2013, 09:40 AM
    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

    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

  • 01-29-2013, 11:29 AM
    Great info

    So how can be overcome these issues ??
  • 01-28-2013, 11:05 AM
    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.
  • 01-24-2013, 12:11 PM
    Thanks Pankaj

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


  • 01-08-2013, 11:03 AM
    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

    Attachment 12
  • 01-04-2013, 12:44 PM

    Monitoring load on capacity of the SQL server


    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.


Posting Permissions

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