Click here to Skip to main content
13,345,954 members (57,715 online)


QuestionSQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 6:13
membercjb1104-Oct-12 6:13 
We've upgraded one of our systems to SQL 2008R2 and certain parts are running like a dog. One statement that would have taken an average of 20-40mins on the old box, took from 11:40 to 00:35. Its not every statement but odd ones.

Its a 2 cpu box, and the cpu usage sits a 50%, there's hardly any activity in activity monitor (no significant resource waits etc, no io, or requests)

Unfortunatley this didn't happen during conversion, system test or uat, so we've imp'ed, and now hitting these issuesFrown | :(

Has anybody got some hints, places to look, good resources to read up on?

One thing we would like to work out, is it a fact, 2008 does things differently and query design, indexes etc need to be re-developed/analysed?
AnswerRe: SQL 2000 to 2008R2 Query Performance Pin
Shameel4-Oct-12 10:01
memberShameel4-Oct-12 10:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 23:30
membercjb1104-Oct-12 23:30 
AnswerExecution plan Pin
David Mujica4-Oct-12 11:25
memberDavid Mujica4-Oct-12 11:25 
GeneralRe: Execution plan Pin
cjb1104-Oct-12 21:58
membercjb1104-Oct-12 21:58 
GeneralRe: Execution plan Pin
David Mujica8-Oct-12 9:54
memberDavid Mujica8-Oct-12 9:54 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 0:41
membercjb1109-Oct-12 0:41 
GeneralRe: Execution plan Pin
David Mujica9-Oct-12 4:12
memberDavid Mujica9-Oct-12 4:12 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 5:34
membercjb1109-Oct-12 5:34 
GeneralHigh CPU Pin
David Mujica9-Oct-12 10:13
memberDavid Mujica9-Oct-12 10:13 
GeneralRe: High CPU Pin
cjb11010-Oct-12 22:30
membercjb11010-Oct-12 22:30 
GeneralRe: High CPU Pin
cjb11011-Oct-12 0:15
membercjb11011-Oct-12 0:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 17 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid