Did some performance counters like Free Pages disappear in SQL 2012?

Answer: Yes. Why were the performance counters changed in SQL 2012?: The Memory Manager component of SQLOS was redesigned in SQL Server 2012 and hence some perfmon counters have been changed accordingly. If you have been using the Free Pages performance monitor counter for monitoring SQL memory usage/pressure under the “Buffer Manager”, “Buffer Partition” or…

2

What is the benefit of installing SQL 2012 on windows 2012?

After the release of Windows 2012, I get questions like what is the benefit of installing SQL 2012 on windows 2012 compared to installing it on Windows 2008 R2. Microsoft recently released the following KB article which answers some of the questions around SQL 2012 support for Windows 8 and Windows 2012 Here is the…

0

Resource Database common Questions

While working with customers, I get quite a few questions on Resource database. Hence I thought about answering some of them in this blog. Some of the questions that I get: Can I access it through management studio? Should I backup my Resource database along with the other system database backups? Can I change the…

11