Re: SQL Tuning Regarding System CPU Stats

From: <andrew.markiewicz_at_gmail.com>
Date: 18 May 2007 08:08:16 -0700
Message-ID: <1179500896.345120.147950@o5g2000hsb.googlegroups.com>

Thanks Connor. That was a good sanity check. I've had a hard time finding any other info supporting my thoughts about a test system so I was beginning to wonder if I had irrational concerns.

>Nothing make a IT shop look
>more stupid than having something signed off in dev/test as "working
>fine" only to have it bog down to a crawl in production.

Precisely what I want to avoid.

>we strive to have our dev/test environments running fill size
>production copies wherever its possible to do so.

Our db is small enough that we are able to make full clones in test, so some of the difficulty involving data volume and statistics disparity is removed.

Do you find it necessary to have different system stats in production for OLTP and batch processing? If so, how do you setup test environments to work with both scenarios? Two db?

Thanks
Andrew Received on Fri May 18 2007 - 10:08:16 CDT