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

    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 (asp.net) 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
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    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
  •