Great...

Perry Whittle (9/18/2012)

---

Hey thanks Grant, i appreciate the vote of confidence

With AlwaysOn features it literally consolidates the functionality of mirroring and failover clustering into...

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within...

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within...

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within Performance Monitor because...

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within Performance Monitor because...

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within Performance Monitor because they're both from...

pooyan_pdm (9/18/2012)

---

SQLSACT (9/18/2012)

---

Thanks

And that would give me an accurate % of plan-reuse in my instance?

What is the Cache...

Will something like this do the trick

declare @cachehitratio decimal(18,2)

declare @cachehitratiobase decimal(18,2)

declare @ratio decimal(18,2)

select @cachehitratio = cntr_value from...

Thanks

And that would give me an accurate % of plan-reuse in my instance?

What is the Cache Hit Ratio...

anthony.green (9/18/2012)

---

http://technet.microsoft.com/en-us/library/ms187743.aspx

For per-second counters, this value is cumulative. The rate value must be calculated by sampling the value at discrete time intervals. The difference between any two successive sample values...

anthony.green (9/18/2012)

---

how are you calculating that number of 10630, is that how it is when you do the select or have you done a comparision between the value at two...

Grant Fritchey (9/18/2012)

---

Yes. If you're trying to set up availability groups, you are dealing with different servers with different storage. Now, that storage could be the same SAN, but each...

Grant Fritchey (9/17/2012)

---

SQLSACT (9/17/2012)

---

Grant Fritchey (9/17/2012)

---

SQLSACT (9/17/2012)

---

Grant Fritchey (9/14/2012)

---

Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor....

Grant Fritchey (9/17/2012)

---

SQLSACT (9/17/2012)

---

Grant Fritchey (9/14/2012)

---

Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also...