editted - removed question

Great. Thanks!

Thanks for the link, Luk.

I see it uses SMO, which I know nothing about.

Are there any SQL2005 out of the box EXE or utilities I can use?

Good information.

I manage SQL Servers (2000, 2005) on VMware Virtual Machines.

I believe using Performance Counters in VMs isn't accurate.

How can I monitor performance (CPU, RAM etc) on VMs?

Thanks for the feedback, Michal.

What about the MINIMUM Memory Setting?

Should it be left at ZERO or set to match my MAXIMUM setting, or... ?

Thanks, Jo. I appreciate your response.

Thanks, webrunner. I'm reading through Brad's book now.

Thanks, Chris.

I will start reading up on PROFILER since this process does not work on SQL2005.

FYI: I've found that using SYS.INDEXES and SYS.XML_INDEXES should work in my environment.

...thanks

Correction, "sys.spatial_indexes" won't be part of my research since it doesn't exist in SQL2005. I only found it in SQL2008.

🙂

Oliiii (9/30/2010)

---

You can do a select on sys.indexes to get all the indexes in your DB.

You can do a select on sys.spatial_indexes to get all the spacial indexes (which you'll...

OK, So sp_helpindex is not the only sql tool in determining ALL the indexes/keys a TABLE contains.

Would SSMS be your one-stop shopping or is there more than one SP...

Thanks, Derrick!

I don't suppose you have a URL handy that shows these in action?

I can check out PROFILER as well, which is new to me.

Thanks for your reply, Pradeep.

According to PROCESS EXPLORER (Properties/Threads) I should be looking for TID=61852

And this process has been running for some time, so it did not disappear before I...