Click here to Skip to main content
       

Database

 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 6:54 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 7:11 
Questionterminating SqlConnection.Open() call while connecting PinmemberDan_K4-Oct-12 7:43 
AnswerRe: terminating SqlConnection.Open() call while connecting [modified] PinmemberShameel4-Oct-12 8:46 
AnswerRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen4-Oct-12 9:10 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberDan_K5-Oct-12 4:37 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen5-Oct-12 4:57 
QuestionSQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 5: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 PinmemberShameel4-Oct-12 9:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 22:30 
AnswerExecution plan PinmemberDavid Mujica4-Oct-12 10:25 
GeneralRe: Execution plan Pinmembercjb1104-Oct-12 20:58 
GeneralRe: Execution plan PinmemberDavid Mujica8-Oct-12 8:54 
GeneralRe: Execution plan Pinmembercjb1108-Oct-12 23:41 
GeneralRe: Execution plan PinmemberDavid Mujica9-Oct-12 3:12 
GeneralRe: Execution plan Pinmembercjb1109-Oct-12 4:34 
GeneralHigh CPU PinmemberDavid Mujica9-Oct-12 9:13 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 21:30 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 23:15 
QuestionMySQL Server timestamp changed! Pinmemberjrahma2-Oct-12 21:53 
AnswerRe: MySQL Server timestamp changed! PinmemberShameel3-Oct-12 4:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit PinmemberSatyam Tripathi2-Oct-12 21:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit PinmvpRichard MacCutchan2-Oct-12 22:00 
QuestionBackup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 10:35 
AnswerRe: Backup/Recover of row data in a multi-Company database PinmvpMika Wendelius2-Oct-12 11:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web01 | 2.8.140721.1 | Last Updated 21 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid