Yes same value is passed. I am updating the statistics now, lets see..

hmm..so what is best way to find fragmentation level on indexes during heavy usage?

Thanks for quick reply. I am trying to understand this in a better way, if your script doesn't match the indexes what are actually used then where can i use...

Thanks for the wonderful article Ian. As soon as i read this article i tested this out on one of our development environments. I compared the results from your code...

Are high memory\page cache faults good?

Sachin Nandanwar (2/1/2011)

---

You are welcome.

Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page...

Sachin Nandanwar (2/1/2011)

---

You are welcome.

Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page...

Sachin Nandanwar (2/1/2011)

---

All counters look fine for me except Memory\Page Faults/sec which are way over the limit.

But before that you need to figure out how many of them are...

Any clue why do i have two plans?

I need to check but could there...

Not sure what do you mean. I have attached...

GilaMonster (1/21/2011)

---

One and only one. A procedure can only have one plan in cache at a...

Eric M Russell (1/28/2011)

---

sqldba_icon (1/25/2011)

---

I am trying to findout is there a specific figure which would specify the % of cache being allocated from the memory. i did total of...

Mike - CI (1/27/2011)

---

Using SQLCLR would be a situation where you would have some .Net code that created a connection that you could dynamically pass into a function or proc...

Grant Fritchey (1/27/2011)

---

Check for contention, blocking, that would make prod run longer than dev. How about the physical machines themselves? I ran into situation once where I spent at least...