current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
up vote 0 down vote favorite

I have an issue with sql server not performing good when compared to old server. The problem is SQL Server is not using all the columns in the index making it fetch over 45 million rows as opposed to about 9000 rows. This makes query run for 16s.

We have an old server more than 3 years old with direct attached drives. The query takes less than a second. This server has 4 processors with 10 cores per processor.

We want to migrate to a new server, the new server has 4 procs with 12 cores with SAN storage. The same query here takes 13s. Same database, all indexes are re-indexed and statistics updated. Any thoughts will help.

share
1  
Your question has no meaning unless you add execution plan from old and new server. It would be really difficult to tell why SQL Server is not performing up to mark on fast server. – Shanky 40 mins ago
    
Thanks for responding. The execution plan is big xml. Unable to add to the comment.... trying to see if there is any other way... – Muthu S 34 mins ago
    
Is max memory same on both servers ? Power plan set to high performance? – Kin 32 mins ago
    
The new one has more but has setup to 256G on both server for testing purposes. – Muthu S 26 mins ago
    
The execution plan for old server is: pastebin.com/vivenH2H – Muthu S 16 mins ago

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.