Yes, links don't work any more. Any chance they can be restored?

Thanks guys, cheers!

Do I have to RDP to the actual server for this to work?

I just did that and it worked!

Does that mean DAC only works once one is collected locally...

Wilfred van Dijk (5/28/2008)

---

If you don't enable AWE on a 64bit server you can get errors like "A significant part of sql server process memory has been paged out. This...

May I suggest a couple of great links on this topic, ones that have helped me tremendously?

Gathering Unused Index Information:

mhtml:http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%201.mht

Uncover Hidden Data to Optimize Application Performance:

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

Thank you for the response and link. That link was actually what prompted my opening post.

Any info on NUMA architecture as it relates to SQL Server performance?

Any experiences anyone wishes...

Manie Verster (5/28/2008)

---

Hi, call me stupid if you want but I like automating/automated things. What I do is run the database tuning advisor and that tells me exactly where I...

Wilfred van Dijk (5/27/2008)

---

You need AWE to prevent memory stealing by the OS.

Also make sure you have a minimum and maximum size. Don't set the maximum size to unlimited,...

Here is a query you can use.

Make sure your SQL instance has been up for at least 1 business cycle (week/month/longer???) before you start eliminating indexes! :w00t:

SELECT

OBJECT_NAME(...

Steve Jones - Editor (5/27/2008)

---

Tend to agree with Michael. Monitor and observe the system. AWE isn't needed for 64-bit and my guess is SQL will keep building cache and run...

To get the total current size of your buffer pool run the following:

Taken...

I would also add, be wary of indexes defined on too many keys (more than 3). These are usually overkill, unless you need a covering index.

Also, as Gail mentioned,...

I ran "dbcc show_statistics" on some of the indexes...

No problem, thank you for responding.

I will be making the case for SQLCLR in an upcoming...

jeff.williams3188 (5/22/2008)

---

If I switch from sysindexes to sys.indexes, I have no access to information as to how many rows in the index have been modified since the latest update. I...