Last post Dec 23, 2014 08:47 PM by Edwin Guru Singh
Dec 22, 2014 06:43 PM|Moayyad.Faris|LINK
I have a new server with top specs and high memory 32G-Ram. My sql server takes about 4 G ram for 2 samll DB (lower than 2G space). The server cpu goes up and down and then its not responding.
The following data is taken from queries stats, please see and advise.
Dec 23, 2014 08:47 PM|Edwin Guru Singh|LINK
As per your case ,I have been shared my suggestion & ideas below :
For your reference, the following link can be guide you to solve your issue :
Sql Server Performance Tuning Tips
Sql Server Database Performance Tuning Tips
Improve CPU Performance of Sql Server Tips
Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft
cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Hopefully this will be helpful for you.