Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
Course Of The Month
9 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Server 2012, high memory usage windows internal database
Posted on 2015-01-05
Hi
I have a server 2012 server. The main dc has two virtual attached running virtual SQL and virtual exchange. The server has got slow! Running task manager shows 5gb usage by sql however we don't have sql installed in the main DC. Within task manager it shows it is something to do with "windows internal database". The server also appears to have a user under c:\users called MSSQL$MICROSOFT##WID. I have browsed around and suggestions are WSUS. However I don't have this installed.
I have a server 2012 server. The main dc has two virtual attached running virtual SQL and virtual exchange. The server has got slow! Running task manager shows 5gb usage by sql however we don't have sql installed in the main DC. Within task manager it shows it is something to do with "windows internal database". The server also appears to have a user under c:\users called MSSQL$MICROSOFT##WID. I have browsed around and suggestions are WSUS. However I don't have this installed.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
-
3
7 Comments
Active 5 days ago
firstly, do you mean you have a server running as a domain controller that ALSO has the hyper-v role installed and in that you have two guest VM's configured?
Thats how the question reads.
What server license do you have to configure this?
This is a very very bad idea and a poor setup at the very least, possibly also breaking the license terms.
Thats how the question reads.
What server license do you have to configure this?
This is a very very bad idea and a poor setup at the very least, possibly also breaking the license terms.
That is how it reads. Also the server licensing is sufficient. The have adequate licensing.
It is a small organisation with 7 users.
It is a small organisation with 7 users.
Active 5 days ago
How man server 2012 licences are used?
By having the DC AND Hyper-V role installed on the host you need a server license for that and one additional VM PLUS another licence for the second VM. That is per 2 physical processors in the host.
What other roles are installed on the physical host apart from ADDS & Hyper-V?
By having the DC AND Hyper-V role installed on the host you need a server license for that and one additional VM PLUS another licence for the second VM. That is per 2 physical processors in the host.
What other roles are installed on the physical host apart from ADDS & Hyper-V?
I am getting confused by your questions as I am not asking about licencing. However I can confirm that it is a single CPU with 2 windows server 2012 standard licences. I understand that a physical instance may only be used to manage the virtual instances. However in this case it is different.
Active today
You MUST have TWO 2012 licenses to be running a DC on the host server (which is HORRIBLE ANYWAY!) and two VMs, one with SQL and one with Exchange. You SHOULD be running all three virtually.
If you don't already have a second 2012 license, you should buy one now, add a second DC to the network as a VM on the same system, transfer the roles off it, then demote the physical DC and make it so it ONLY runs Hyper-V.
You should limit the amount of RAM the Windows Internal Database can use. Follow directions here to limit the RAM
http://www.stugr.com/2013/01/wsus-limit-sql-windows-internal-database-memory/
(Copied from above link for command line method; GUI method in link).
Open a cmd window
Enter the following command depending on version:
For WSUS 4 (Server 2012:
osql -E -S \\.\pipe\Microsoft##WID\ts
For WSUS 3:
osql -E -S \\.\pipe\mssql$microsoft##
Enter the following commands:
exec sp_configure 'show advanced option', '1';
reconfigure;
To view currently set max server memory:
exec sp_configure;
go
To reconfigure:
exec sp_configure 'max server memory', 2048;
reconfigure with override;
go
quit
Restart the SQL service
If you don't already have a second 2012 license, you should buy one now, add a second DC to the network as a VM on the same system, transfer the roles off it, then demote the physical DC and make it so it ONLY runs Hyper-V.
You should limit the amount of RAM the Windows Internal Database can use. Follow directions here to limit the RAM
http://www.stugr.com/2013/01/wsus-limit-sql-windows-internal-database-memory/
(Copied from above link for command line method; GUI method in link).
Open a cmd window
Enter the following command depending on version:
For WSUS 4 (Server 2012:
osql -E -S \\.\pipe\Microsoft##WID\ts
For WSUS 3:
osql -E -S \\.\pipe\mssql$microsoft##
Enter the following commands:
exec sp_configure 'show advanced option', '1';
reconfigure;
To view currently set max server memory:
exec sp_configure;
go
To reconfigure:
exec sp_configure 'max server memory', 2048;
reconfigure with override;
go
quit
Restart the SQL service
Active 5 days ago
The reason I am asking is that if you have 2 Standard licences then you should have set up Windows 2012 server with Hyper-V role installed on it and nothing else. Then add 3 VM's, one as an AD and DNS server and the other 2 being the ones you have installed.
The configuration you have is not a supported configuration and as you have found, is prone to problems.
If ALL you have installed is server 2012 with Hyper-V on the Host then you know EXACTLY where to look when you have host issues.
Is it possible you can back up the VM's and reconfigure? It will be a much more stable and supportable configuration after.
The configuration you have is not a supported configuration and as you have found, is prone to problems.
If ALL you have installed is server 2012 with Hyper-V on the Host then you know EXACTLY where to look when you have host issues.
Is it possible you can back up the VM's and reconfigure? It will be a much more stable and supportable configuration after.
Featured Post
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits y…
A procedure for exporting installed hotfix details of remote computers using powershell
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 3 hours left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.