Thanks Andreas, I don't have too much experience with XEvents - do you mean run a query like this? SELECT * The Windows Server 2012 with SQL Server 2012 SP1 running on it is averaging 62% CPU usage.Īll the databases I'm migrating to the new SQL Server 2012 came from the SQL Server 2008 R2 server, so I think this has something to do more with the setup or configuration of the SQL Server not the databases.Īlso - I have Max Memory set 35 GB on the SQL Server 2008 R2 and 45 GB on the SQL Server 2012 right now to try to eliminate memory pressure on the OS. The CPU usage on the Windows ServerĢ008 server where the SQL Server 2008 R2 instance is running on is averaging 8%. The SQL Server 2008 R2 instance still has our heavy users on it. Here is an example, I have 100 of the smallest databases on SQL Server 2012 right now that I've migrated from the SQL Server 2008 R2 instance. 0 (X64)Įnterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor) Thanks Alberto, I'm using SQL Server 2012 (here are the results from SQL Server 2012 (SP1). In a clustered environment, is this normal and if not, does anyone know what this means or how to reduce the CPU usage? , CONVERT(BIGINT,(tblSysprocess.cpu * CONVERT(BIGINT,100))) / CONVERT(BIGINT, cte.totalCPU) as įrom tblSysprocess Running the following script: with cte () as (select sum(cpu) from ) SQL Server 2008 R2 instance even though the there is only 1/2 of the databases migrated to the 2012 instance. What we've noticed is that the CPU usage is much higher on the SQL Server 2012 instance than on the previous The process in which we are migrating is that we're moving a few databases over to the new SQL Server 2012 instance each night. (meaning the RAM and CPU are both the same or better on the SQL Server 2012 instance) The setup is identical for the SQL Server 2012 instance as it is on the SQL Server 2008 R2 instance. We are currently in the process of migrating an existing clustered SQL Server 2008 R2 instance over to a clustered SQL Server 2012 instance as we phase out the Windows Server 2008 with SQL Server 2008 R2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |