If you run

select r.session_id, r.status, r.command, t.pending_io_count

from sys.dm_exec_requests r

join sys.dm_os_tasks t on r.task_address = t.task_address

order by 1 desc

you should see that pending_io_count for currently running user requests will be low,...

Why create a new database? You could have just detached, copied files and attached again. The MDW collectors would have continued using the same database.

@Andy.gardner

When you say "remote connections are enabled" are you referring to the TCP/IP protocol in Configuration Manager? If not, check it - it is disabled by default for...

The above link is for SQLIOSim - not the same thing.

Brent Ozar has a clear explanation here. http://www.brentozar.com/archive/2008/11/storage-performance-testing-with-sqlio/

I'm using pretty much every build from the last few years 🙁

I don't remember which build produced the xml that Jonathan's code couldn't handle, but I remember it was for...

Did you read the linked article from opc.three's first reply? It states in there that "you can't save this XML document as a .XDL file and open it graphically...

In some circumstances the workaround in the linked article for the invalid xml in earlier builds of SQL Server won't work. I've come across a few situations where a...

Yes. It is the total amount of time it took to execute, in microseconds.

To look for it within a 1 hour window, 2 hours ago - and assuming you know the procedure name:

select qs.last_execution_time, qs.last_elapsed_time, st.text

from sys.dm_exec_query_stats qs

cross apply sys.dm_exec_sql_text(qs.sql_handle) st

where last_execution_time between...

Assuming you are using SQL Server 2005+ you can simplify this with the xml data type.

DECLARE @doc xml;

SET @doc ='

<Survey>

<SResult SectionId="1" SectionName="Ownership" QuestionId="9" UserID="2" Answer="1" Status="checked" />

...

If you were installing this on a server for production use I would recommend a domain account. But you are installing on a Windows 7 desktop so presumably this is...

The effect of fragmentation depends on whether in order scans are being performed - common in reporting databases - and also on the size. There is no real benefit with...

What is the default language of the login you are using for the import?

If English, try changing it to British English.

Without knowing exactly how SSIS is handling the data I...

I have done this between SSRS 2008 R2 and SQL Server 2005 for the databases.

So in theory it should work OK on 2012 and 2008 R2

The default trace records which login is responsible for file autogrowth. This sometime shows as sa, for example during some system operations, but it is worth a try.

Here's the...