Post reply

Problem with performance

  • May 18, 2006 at 4:37 am

    #152982

    Hi to everybody,

    I've got a problem with slow performance in a server. This is the scenario:

    1. Server bi-processor XEON 2.8 GHz;
    2. 4 GB ram;
    3. S.O. Windows 2003 std edt with SP1;
    4. MSSQL server 2k with SP4;
    5. Terminal Server.

    During the normal accesses, I see on the task manager that the sqlserv process increases the use of RAM until the value that I setted on the memory task on the properties of the service, and all  clients work well. When the process reaches the maximun value (setted at 2048 GB), all the operations on the server become slow and block some terminal session. If I restart the service the operations became fast. It's the worst way to solve the problem to restart sql service. Is there a better way, or is there a good configuration to increase the performance of the server?

    Kindest Regards,

    Keno

  • May 18, 2006 at 9:09 pm

    #638905

    Hi,

     

    Have u selected both the processor in ur sqlserver property task.

    Have u enabled awe for 4 GB memory usage.

     

    HTH

    Killer

  • May 19, 2006 at 4:53 am

    #638937

    How many Terminal Server sessions?

    You have alocated 1/2 the server memory to SQL Server, and left the rest to be shared by the OS and Terminal Server clients, so I suspect that you have somewhere like 1GB available for Terminal Server sessions.

    SQL Server will use what you tell it to and may not release it fast enough if the server is too low on memory. I would look first at the Kernal (non-paged) memory during those times when the Terminal Server clients are complaining.

    I'll bet that you should reduce the memory alocated to SQL Server until you reach a median between SQL and TS performance.

    Best solution, give SQL Server a dedicated server.

    Andy

     

  • May 19, 2006 at 9:36 am

    #639041

    SQL Server 101 - a SQL Server is a dedicated machine. Dedicated to SQL Server alone.

    So I agree that TS has no place on the SQL Server. We have a dedicated TS and it can come to a crawl oll on it's own - it's a quad Xeon, 3.0 Gh CPUs and 8 Gb RAM ! In the event you cannot get another server, then you definitely need more RAM. 2 GB for SQL Server, 2 Gb for the OS and at least 2 Gb for TS - don't forget TS user RAM alllocations as well. Think of perfmon as a 'friend'. It's information will help you justify any hardware upgrades/purchases that are needed.

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • May 23, 2006 at 11:17 am

    #639564

    Wrong forum, this is the Notification Services forum.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply