Poor MSSQL server performance on virtual machine after system upgrade

Vote count:

0

I'm managing middle sized company database. Recently we have massive system upgrade and switched to virtual machine environment. After deployment, we are having performance issues, Appereantly MS SQL SERVER on upgraded system works slower than older configuration.

Here are the configurations:

Old Server: SQL SERVER 2008, 10gb Ram, Intel Xeon E5420 x2 (Physical Machine) runs windows server 2008

New Server: SQL SERVER 2014, 64gb Ram, Intel E5 2660 x4 (virtual machine) runs windows server 2012

very basic IO performance comparison follows as:

new server: http://ift.tt/1FvpmMs old server: http://ift.tt/1Fvpo72

even with the most basic operation: from most used tables runs more amount of time to retrieve result. Also stored procedures runs slower.

example:

(new server: 01:39 minute, 3285365 rows) (old server: 01:00 minute, 3339738 rows)

I have no idea what could cause this problem. Any help will be appreciated..

asked 38 secs ago

incxbxs

1

Poor MSSQL server performance on virtual machine after system upgrade