Jeff Moden (8/21/2014)

---

Personally, I think it's a waste to set a FILL FACTOR to anything less than 70.

Some questions to ask are, is this index actually being used for anything?...

Thanks for your response! appreciate it !

Yes I use SOLARWIND to monitor SQL Performance and...

Andrew G (8/18/2014)

---

Sorry, that refers to the location of the Default Trace. Also the previous query has the database name set there.

Run the following to find the default...

Andrew G (8/18/2014)

---

From http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

SELECT

loginname,

loginsid,

spid,

hostname,

applicationname,

...

GilaMonster (8/15/2014)

---

Your largest memory consumer won't be a query. Most of the memory will be...

Andrew G (8/14/2014)

---

SQL will buffer as much as it can according to the Max Memory setting.

To check which database is using most of the buffer pool, run the following query...

Thanks all ! Appreciate your responses!!

ahhh yess you are...

Shurgenz (8/4/2014)

---

when creating the new index on a large table that already has some indexes, the new index could take a long time when tehre is alredy index with...

SQLRNNR (8/3/2014)

---

Ok, that tells a tale of a much smaller table than what you were showing before.

I bet there was blocking, or memory thrashing, or slow io, or any number...

SQLRNNR (8/3/2014)

---

WhiteLotus (8/3/2014)

---

SQLRNNR (8/3/2014)

---

Did you check the status of the index creation while in progress? Did you check for blocking?

Does the dev server have just a small amount of...

SQLRNNR (8/3/2014)

---

Did you check the status of the index creation while in progress? Did you check for blocking?

Does the dev server have just a small amount of RAM or...

ScottPletcher (8/3/2014)

---

8 hours seems extraordinarily extreme for 172M rows. It seems like there must be more to the story.

Are you changing the clustered index on the table? Does...

Jeff Moden (8/3/2014)

---

WhiteLotus (8/3/2014)

---

Jeff Moden (8/1/2014)

---

You could disable them which drops all of the data from the index but keeps the meta data and see if peformance suffers. Of...

GilaMonster (8/3/2014)

---

That counter is misleading....