If I set up the server side trace, my understanding is that it would only collect the information going forward. I wouldn't tell me...

My understanding is that the server side teace will not be retrospective and so will not achieve what I am looking for. I go back to my original question.

I...

sys.dm_db_index_usage_stats tells information about usage of indexes.

Yes it does, but it also tells when an index was last scanned, in the columns i mentioned. Hence at the moment...

hi_abhay78 (5/29/2009)

---

so its trying to create the sparse file , hitting the latch waittime issue ..

I am very sure that you are also getting the dump generated ..

i know of...

Have tried this twice but it has not resolved the issue. We have no backup of the msdb because the company that adminied it previously "didn't see the point of...

Apologies that's a typo it should read IIS.

Thanks for reply. We have just solved it. SQL Server was installed on the server without SSIS, hence no SMTP components, hence no email.

Thanks to everyone for there help.

In the end we had to transfer it to another server that was on a lower service pack level. It was the only was we could get around it....

I have spoke to the most experienced hardware guy that I could find.

He’s unsure what you me by “power cycling the IO subsystem”. He suggests that it either means a...

Thanks I work in the network teams and have had the hardware guy give the system a look over previously, and he has found no issues with the hardware.

However we...

Paul Randal (5/20/2009)

---

. It's more likely an IO taking too long. Can you look in the error log for any errors saying something like an IO failed to complete or...

John Marsh (5/20/2009)

---

Hello again,

Did you ever get to the bottom of your issue?

If so, could you post the resolution?

If not, in which of the msdb items views did your...

No NTFS compression or third party applications:

Get the following message when I look in the SQL Log:

Time-out occurred while waiting for buffer latch type 3 for page (1:712)

They are eithier temp file ie. tm344.tmp or ~vs2E0 sql server query files. But it only fills up when we are running a long sql server query.

I have run it without the tablock part before and I get:

Msg 1823, Level 16, State 2, Line 1

A database snapshot cannot be created because it failed to start.

Msg 7928,...