As usual Gail I owe you my thanks.

Thats much clearer now.

I'm a little confused, you said the...

GilaMonster (1/18/2012)

---

Limited just shows you the leaf level of the index, so that 101 pages is the number of pages in the leaf level.

Detailed shows you all the levels of...

Firstly I think you should be automating your CHECKDB.

Secondly, if you saying it's not in the log but your query say's it has been run then that's odd.

The way I...

I shall find out now and let you know.

Thanks,

Nic

I knew I forgot something, the log buffer.

Thanks for clearing that up for me Gail, we were talking about CHECKPOINT and I got myself confused (again).

Enjoy the new year.

Nic

Cracked it, I was being silly, the DBCC dbinfo() command takes the dbname, so I can just pass it in to that.

Problem solved.

Regards,

Nic

My final issue now is getting it to run on a specific database, rather than just on the master db.

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=SERVERNAME;Trusted_Connection=yes;',

...

Think I may have resolved it, bit more research and it turns out the below works;

'SET NOCOUNT ON; SET FMTONLY OFF; exec (''dbcc dbinfo() WITH TABLERESULTS'')')

It's the FTMONLY OFF which...

Great question.

Got it wrong as I did not fully read the INSERT statement.

Still, it's ok, the lesson learnt today is, always read the question properly, even on a Monday morning....

It may just be me, but I wouldn't class this a bug, if that's what are you are saying, the AS...

Thanks for the question Steve.

It was one of those nice ones where I knew the answer, but thought, hmmm, is there a trick to this.

Made me think a little, but...

Grant Fritchey (9/29/2011)

---

But wait, if your CPU is maxing out, what makes you think it's memory pressure? I can see I/O issues from memory pressure as more and more stuff...

Thanks Gail, that makes a lot more sense now.

Nic

Thanks Matt, I'll have a read through it now.