Les Cardwell (3/24/2010)

Steve Jones - Editor (3/24/2010)

I'd like to see this start going, though I think we need a forum, and a long debate on the PASS site. We probably...

From BOL:

DBCC Logical Scan Bytes/sec

Number of logical read scan bytes per second...

Yes, you need to run the setup from 64-bit. SQL Server 2008 is at SP1 right now, so you'll need that.

I believe if you let it autorun or click...

Bill Nicolich (3/24/2010)

I mean, let's do Denver everybody! Wait. Where did that idea come from? It just popped in there.

We could throw a barbeque in Steve's backyard. We'll get sauces...

IF the user needs to access the production server than you need the user on the production server.

If you are using the stored procedure command type, which you should be, then they will be RPC.

DBCC Logical Scan Bytes/sec is not a DBCC command it is a performance counter. Are you seeing any DBCC commands being run. I know that RedGate SQL Prompt...

Try checking these installation instructions

All the WA_SYS stuff is system generated column statistics.

This query provides a bit more information than you need, but will help you query the Default Trace better:

With cteObjectTypes AS

(

SELECT

TSV.trace_event_id,

TSV.subclass_name,

TSV.subclass_value

FROM

sys.trace_subclass_values AS...

I don't think you gain any benefit from having 2 partitions on the same array. If you are using pre-WIndows 2008 you should make sure you have your partitions...

Nah, don't worry about the location. It just means that you might get different answers because things change from version to version. Not as big a deal when...

Because they use DMV"s you need VIEW SERVER STATE and/or VIEW DATABASE STATE.

http://technet.microsoft.com/en-us/library/ms188754.aspx

Hmmm, that's an interesting one. I'm just guessing here, but the application is probably creating that table somewhere. Is that table referenced in the function?

I'd do a trace...

Since you are talking 2008 you should have posted in a 2008 forum. Are those 4 drives going to hold everything (OS, Data, Logs)? What are you projecting...

Paul Randal has an older blog post about autoshrink on the Storage Engine Blog. It says:

The algorithms that shrink use are basically brute force. It starts at the end...