while we are there dbcc updateusage(0) as well

Thanks for all the interest guys I appreciate it but the SSD was only on temporary loan so we thought we would a have a look to see what it...

Just for Info the ETL process we used during the testing runs for about 20 hours and shifts about 200GB of data (thats the size of the database it creates...

have the statistics been updated since the upgrade?

there's still the race to 1000000 posts after steves 'tidying up' of SPAM.

So we could hit 1000,000 actual posts in the 'posts' table,Steve could delete some SPAM, we could reach...

Cannot stop yet, the actual no. of posts...

Alvin Ramard (10/6/2010)

---

You should have...

and apologies it does not include dbs not backed up, those would be filtered out by the where clause.

Thats OK, I have to think about it too.

Heres a URL with some examples using Coalesce. I haven't tried them.

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=LastBackUpDate

just gearing up for 1000000 and I got 'threaded.' Should have known.

congrats Alvin.

raschen daschen.:pinch:

Robert Frasca (10/6/2010)

---

It's kind of bizarre that you're not seeing any improvement. One of my colleagues at this client site told me they had moved TempDB to an SSD...

Unless your files are tiny in which case you may as well do full restores from the primary I don't think you can fit this process in 5 mins.

but I...

manufacturer is STEC, judging by the model no from their Zeus range.

The process is a heavy user of Tempdb. We also tried user database log and data files on SSD...

its in the attachment

where does the 5 minute update interval fit into that process? Have I misunderstood in thinking that you wanted you reporting databases near real-time?