June 27, 2014 at 10:35 am
Trying to migrated to new server with client. Seeing peformance issues from the applicaiton end, going from sql 2005 12 core to new 2008 r2 64 core, 64 gig of memory and new san. Cleared proc cache (after hours) and ran selects, 2005 server twice as fast with 100 users, 2008r2 new server no users. Tried to take it to simple approach rebuilt all indexes on new super server (standard edition) took about 3.3 hours. There are no users on system, tempdb multiple devices on own disk as are all the data files and index files on own disks. Ran same index rebuild against same database on test server with 2008r2 standard 12 core, 16 gig of ram, tempdb and data files all on same disk. Took same amount of time. Might be a simpleton, but there is no way the times for the test server and this new high velocity server should be the same, no users, rebuild was all that was running. We dont have sysadmin on this new high priced box at client so limited in what we can look at. Am I missing something I see no way the same index rebuild on the different of boxes should be the same.
June 30, 2014 at 4:44 am
Have you looked at the wait statistics to understand what the server is experiencing waits on? Further, capture the waits at the start of one of the slow processes and at the end of it in order to understand what is causing that process to slow down. It could be memory, CPU, I/O, almost impossible to know. There are a large number of server settings it could be. But, in order to narrow it down, let's get the wait statistics and we'll know where to focus.
"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
June 30, 2014 at 6:02 am
I would also suggest to check the power setting on new server.
June 30, 2014 at 8:50 am
Will look more interested in IO times. Same database same sp_configure settings, indexes and stats rebuilt on both server. Only difference is one is older vmware server at our site only 16 gig ram, 8 core. Othere server at their site brand new dell, brand new san, 64 gig of ram and 64 core.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply