No, nothing to do with virtual servers at all. How SQL allocates and what Task Manager doesn't show

Best way - target and total server memory

Don't use Task Manager to check SQL Server's memory usage. It will often display completely incorrect values.

Run the following, post the full, complete and unedited output

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

There's no corruption there, so no errors that need fixing.

Service packs are not fixes for database corruption, not that you have any anymore.

A. A. (2/15/2013)

---

Obviously 32 bit OS couldn't "handle" more than that or it would have, and there would not have been a limit. Instead, it let you enable relinquishing...

Fragmentation, probably not. Low page density (a side effect of fragmentation), hell yes. Having half of your expensive SSD going to waste because of low page density isn't the greatest...

A. A. (2/15/2013)

---

You and I both know they didn't squeeze more money from you to lift the 32 bit OS limits. We paid good money for SQL that rightly...

sql-lover (2/15/2013)

---

Thanks for...

Been that way well before the 32 bit/64 bit changes.

The same...

The OS wasn't the limitation in 32-bit days. The addressable memory by a 32-bit process was.

It's used for the cluster's IsAlive check. It takes minimal resources. It wasn't there on SQL 2008 or below because it was only introduced in SQL 2012.

Nope. To get around 'artificial' memory limitations on Windows Standard edition, upgrade to Enterprise.

p.s. New questions in a new thread in future please.

If the repair ran and completed, then the corruption's gone. If you have more problems, some detailed descriptions would be useful.

tony28 (2/15/2013)

---

it was just on test DB, if i did this test http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx and after appeared error with FULL

BACKUP LOG and when I wrote command dbcc shrinkdatabase ('Your-Data-Base-Name', TRUNCATEONLY)...

Why do you want to shrink (make smaller) a log that is complaining it's full (not large enough)? Seems rather counter-productive to try and reduce the size of something that's...