I have a server running windows Server 2008 64 bit with SQL Server 2008 64 bit r2 installed. There is 32 GB RAM.
I am noticing 100% memory use by SQL server. I have read plenty of articles stating that SQL server will use as much memory as is available. My question is surely MS have released a patch or process to control this usage?
If I restart the SQL service, meory usage drops and it grows again over a few hours.
Has anyone seen similar behaviour and if so, what can you recommend to manage this usage to keep it performing well?
Within the configuration you can limit how much memory SQL will use.
When in SSMS right click on the Database instance, and select properties. There is a memory and processors settings. You should choose
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012.
Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…