the database performance problem

Posted on 2012-09-17
Last Modified: 2012-12-28
some users informed us that the database Sales access is very slow and the timeout errors come up..when we check the server cpu and ram usage on this server, there seems to be normal but we can not find where the problem is located so could you please explain how to perform a database performans check or a tuning
Question by:TRocex
    LVL 5

    Assisted Solution

    This is a very subjective question for now. There could be numerous of reasons why the database is not responding well

    You should start by narowwing down the possibilities.

    Start with identifying the queries/objects, in database that can be the cause of this delay. I assume you have a front end app that basically uses this database. If so, try to find the forms/interfaces on that app which are taking longer than usual. Then analyze the database objects including tables and stored procedure or sql queries being used to query the relevant tables.

    You can use Sql profiler to identify the sql batches that are taking time. Then you can use Query Execution plans in Sql Server Management Studio to help you give a more detailed picture of exactly what could be taking time in each query.

    But even before you get into this stuff, try to see if your sql server is responding? This can checked by trying to connect to the concerned sql server using a sql server management studio on a different machine.

    if not, probably some network latency may be causing the delay.

    Let me know if you need more help.
    LVL 10

    Expert Comment

    1) check for blockings on the database
    2) check for missing indexes,
    3) in dex fragementation usinG DBCC SHOWCONTIG
    4)LOCKS ON the database using sp_lock

    Author Comment

    thanks so much for your great information but I am not experience in Sql server so I think I dont know how to find and apply feedbacks you say..could you please send me a document or detailed information?
    LVL 5

    Assisted Solution

    This is a one stop shop for all that Microsoft suggests for optimizing Sql Server performance.

    Alternatively, you can use the following links

    This one will help you optimize the stored procedures

    This is another good article to refer to

    Author Comment

    I would like to ask how to check the missing index and what to do after finding missing index?
    LVL 5

    Accepted Solution

    You can use Sql Server Index Tuning Wizard from within the Sql Server Management Studio

    It will suggests what indexes can be created. You can then create those indexes

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now