Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012

    Exclamation Unanswered: Server Performance

    Good day to all!
    I'm new to SQL server environment...
    right now, we are using it to our client.
    I would like to check if the server is in the optimize settings or utilizing its cpu cores (8 cores) and memory capacity (8 gig).

    Scenario is that our web apps ( is having performance problem.
    Single user on a particular module will have an estimation of 4-5 sec data retrieval (stored procedure was used to retrieve data). row count of the table is 600,000+ records (optimized with indexes).

    When we add 2 or more users, data retrieval estimated to 25-30 secs.

    What should i do to optimize and maximize its performance?

    Server specs:
    CPU: Quad Core(2 cpu, 8 core)
    Memory: 8gig
    OS: Windows 2008 (32bit)
    SQL Server: 2005 Standard Edition

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    You should start by learning and using some tools, like: Windows System Monitor, SQL Server Profiler, SQL Server Activity Monitor. They will show you what's happening in your server.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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