SQL server 2008 R2 (Performance after installation)

  • Hello

    I hope you are fine.

    I need your support because recently I installed a new SQL server 2008 R2 in Windows 2012 R2 data center but after installation I have seen that the server performance is not good

    Honesty speaking I don’t know if I need to do a special setting or tuning for this new version with the new windows

    Detail

     OS: Windows 2012 R2 data center

     DB: SQL Server 2008 R2 (With SP4)

     RAM: 10 GB

     Server in VMware

    If you have any recommendation please let me know I really appreciate

    Thanks

  • Not enough to go on. What do the wait statistics look like? What is causing the server to run slow. Is it slower than another server? What are the differences between the two in terms of settings? There's just too much that it could be to point to where you need to look.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Hello Everybody

    Let me clarify my question

    Basically I had 2 server with Window Server 2003 SP2 and SQL Server 2005 (Enterprise) and every server had some application.

    Last week I created two new servers with

    OS: Windows 2012 R2 data center

    DB: SQL Server 2008 R2 (With SP4)

    RAM: 10 GB

    Server in VMware

    After server creation I migrated the DB of the application to the new server but currently the performance in the new server is not so good because the response is slower that old server and in some cases the new server behavior is strange (The SQL Server take the 100% of the CPU and we don’t have any SQL process running) as though the SQL server did not release something

    At the beginning I was thinking that the root cause of the troubles was the application and DB of the application but when I finalized the second server my perception changed because the second server behavior is similar.

    Basically right now I have two new servers with the same behavior but different application for that reason I was thinking that the root cause of the trouble is the lack of some setting in the new SQL Server because in the old server I didn’t have this behavior

    For that reason I want to know if somebody have any recommendation that I need to consider in the new Windows 2012 R2 data center and SQL Server 2008 R2 (With SP4) that in the old version was not important or necessary

  • Like Grant said, this isn't much to go on. I've never virtualized SQL before, so I don't consider myself qualified to address that part. I'm going to start with this part of your post:

    lgluna20 (3/11/2016)


    After server creation I migrated the DB of the application to the new server but currently the performance in the new server is not so good because the response is slower that old server and in some cases the new server behavior is strange (The SQL Server take the 100% of the CPU and we don’t have any SQL process running) as though the SQL server did not release something

    At the beginning I was thinking that the root cause of the troubles was the application and DB of the application but when I finalized the second server my perception changed because the second server behavior is similar.

    So you have a SQL Server instance with 10 GB RAM. The SQL Server has pinned the CPU but you don't have any queries running.

    1. What CPUs does the hardware have? How much CPU do you have allocated to your VM?

    2. How much memory is the SQL Server process consuming? Is it hitting the page file?

    3. How many databases are in your instance and how big are they?

    4. What's your max server memory setting for the instance?

    5. What else is running on the server?

    I don't have enough information to actually know what the problem is. I'm guessing it's more about the hardware because you said you don't have anything running and you're CPU is still pinned. Then again, without a lot more information, I'm only guessing.

  • There are a lot of moving parts here, especially with the introduction of VMs into the mix. You're going to have to go through the settings on the servers, look at stuff like anti-virus software, settings inside SQL Server, stuff like that. There's not a "make it run faster" switch that I can tell you to flip. It's something wrong though. You shouldn't be seeing what you're seeing. You just need to investigate more to understand why you're seeing it and what to do about it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thanks you very much for your answer

    I understand that I didn't allocate clear information but basically I don’t have too much information because I didn’t do any change in the system I only change version

    For that reason I wanted to confirm if you have any recommendation with the next spec

    OS: Windows 2012 R2 data center

    DB: SQL Server 2008 R2 (With SP4)

    Server in VMware (Virtual Machine)

    In the last version I didn’t do any special setting but im thinking that in this new version of SQL or Windows I need to do a special setting but I have not identified with one.

    Do you have any document or link or comment to support me please?

    Thanks in advance for your support

  • Again, no. There's not enough information to make intelligent suggestions. You've listed an OS and version, SQL Server version, and the fact that you're running on a VM, but not even what kind of VM. VMWare or Hyper-V or something else? If it's VMWare, go to the VMWare site and search for SQL Server, they have suggestions on how best to configure the VM. If it's Hyper-V, same thing, but go to MSDN.

    As for the OS and SQL Server, without knowing the number and type of processors and the amount of memory, there's nothing you should do or change, let the default install do all the work. With better information, suggestions could be made, but there's nothing magic that I have that lets me know what's going on at your site so I can tell you what to do.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 7 posts - 1 through 6 (of 6 total)

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