meta user
network profile
| bio | website | brentozar.com |
|---|---|---|
| location | Chicago, IL | |
| age | 39 | |
| visits | member for | 2 years, 4 months |
| seen | 1 hour ago | |
| stats | profile views | 461 |
I'm a Microsoft Certified Master, MVP, a SQL Server consultant, and a published author. I've got over a decade of experience with databases, hardware, storage, performance tuning, and virtualization.
BrentOzar.com - my blog & consulting company
@BrentO on Twitter
|
Mar 31 |
awarded | Revival |
|
Mar 31 |
comment |
Definitive list of steps for SQL Server baseline testing? @EricHiggins Generally I'd say an OS restart is overkill unless you're running a 64-bit Windows box and you want to absolutely eliminate the problem with file caching. This post is a little dry, but it explains the issue in detail: blogs.msdn.com/b/ntdebugging/archive/2007/11/27/… |
|
Mar 28 |
comment |
Definitive list of steps for SQL Server baseline testing? @EricHiggins Exactly, an instance restart is better if you can do it because you'll also be resetting all the DMVs. |
|
Mar 28 |
comment |
Definitive list of steps for SQL Server baseline testing? @EricHiggins Okay, perfect. In that case, don't do update stats - use the same stats from the database every time. I'd also make sure all SQL jobs are disabled, make sure no other queries run on the server during that time (like with logon triggers or Resource Governor). Just because I'm anal, I'd do the database restore and then restart the instance - that way I get clean DMV metrics for things like filesystem access times to see if they're varying across tests. |
|
Mar 28 |
comment |
Definitive list of steps for SQL Server baseline testing? @AlexKuznetsov I'm not the one doing the testing, actually - Eric is the one who asked the question. When I do this kind of work, I do look at CPU metrics at the query level as well as the server overall. |
|
Mar 28 |
comment |
Definitive list of steps for SQL Server baseline testing? @EricHiggins Rather than testing multiple things at once, I'd test the pieces individually. I'd rather test queries directly and see what changes impact performance there. For example, run a SQL trace while performing specific functions in the app, and then keep replaying that trace while making index/config changes to improve performance, and watch things like logical reads and CPU metrics in traces. |
|
Mar 27 |
answered | SQL Server 2012 backward compatibility for backups with 2008 |
|
Mar 27 |
answered | Definitive list of steps for SQL Server baseline testing? |
|
Mar 25 |
comment |
How can I add a rowversion column to a large table with minimal downtime @MichaelJSwart yeah, ideally you start the process on a Friday afternoon to minimize the effect on end users, and try to get it done before Monday morning. Once it's in place, you can change the view to point to just the new table, and the craptacular execution plans go away. Ideally. ;-) |
|
Mar 21 |
answered | How can I add a rowversion column to a large table with minimal downtime |
|
Mar 13 |
comment |
Does an IOT guarantee order in a select? @MartinSmith - you can read the full details in the Books Online page. You need to be on Enterprise Edition (not Std) and multiple queries need to be scanning a table that's too big to fit in memory. |
|
Mar 7 |
answered | Does an IOT guarantee order in a select? |
|
Feb 23 |
answered | Is there a way to force Deferred Name Resolution even if the table exists when creating a sproc? |
|
Feb 8 |
awarded | Nice Answer |
|
Jan 25 |
answered | copy ldf from one server to another |
|
Jan 13 |
awarded | Yearling |
|
Jan 2 |
awarded | sql-server |
|
Jan 1 |
answered | Could not continue scan with NOLOCK due to data movement SQL Server 2005 |
|
Jan 1 |
answered | How to find out the activity which increasing the response time of the Sql Server? |
|
Jan 1 |
answered | SQL Server 2012 Installation Error |
