Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013

    Unanswered: Data base Performance

    Hi ,

    We are working for MNC and we have a local server with SQL Server Database on which we design reorts For MIS.
    Capaclity of Hard disk on server is 800 GB and mostly only 150 GB space remain in hard disk. So may i knw low space is the reason for slow Database Performance because query are runing very slow nowadays and if it is true then which kind of action we should perform on database to improve speed of query processing.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Low disk space is not normally a bottleneck. Have you looked at CPU usage, Disk I/O, and Memory pressure? Have you checked to see if there are queues building on the CPU, or the disks? How do these performance metrics hold up against your baseline? Have you checked to see if there are long running queries that can be tuned? Are your index statistics up to date? Do you have appropriate indexes on the tables?

  3. #3
    Join Date
    Jan 2009
    United Kingdom
    Attempt to find the slowest running queries and check the execution plans. Apply some optimisation on the queries ,

Posting Permissions

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