Team,

I am facing a problem with one of the customer due to SQL server, utilization keeps on increasing and even if there is no transaction or query to DB the utilization is still high and doesn't reduce and once the utilization reaches to 90% to 95%. Server hung also the application is not able goes to freeze mode. It doesnt response untilll we restart the server. Please let me know is there fine tuning we need to do on SQL server.

Hardware Spec: Server is having 4 GB., CPU: 2,80 GHZ, Windows 2008 r2.

does the server have any other application other

than SQL server. You can use Adam mechanic sp-whoisactive to track what's going on...

or use SQL profiler or extended events..

1) sp_who2  :-see  active session

2) see above session using dbcc inputbuffer

3) see blocking and traceon 1222,1204 for track deadlock.

4) see running jobs and check error logs.                                                                           

Performance Dashboard Reports help with identifying CPU usage, IO activity, blocks, bottlenecks, missing indexes, etc. As the values for the reports are mostly obtained from
 dynamic management views, such as sys.dm_os_performance_counters,
 sys. dm_os_memory_clerks, sys.dm_exec_requests, etc. no overhead 
is added to monitor the performance. To be able to query these views,
 the SQL Server login must have the VIEW SERVER STATE server
 permission. 

• Edited by Dinesh Vishe 16 hours 6 minutes ago

When you say SQL Server utilization is it CPU or memory ? From what you said it seems like memory. Can you please confirm

Utilisation of what reaches 90-95% CPU? Memory? Something else?

Your post is not very informative. It's like calling the doctor saying "I'm feeling awfully bad, what medicine should I take?".

The one piece of information that is useful in your post is that the server only has 4GB of memory. That is not a lot.

As a start, could you at least post the output from "SELECT @@version"?

How memeory assign to sql server ?

1) sp_who2  :-see  active session

2) see above session using dbcc inputbuffer

3) see blocking and traceon 1222,1204 for track deadlock.

4) see running jobs and check error logs.                                                                           

Performance Dashboard Reports help with identifying CPU usage, IO activity, blocks, bottlenecks, missing indexes, etc. As the values for the reports are mostly obtained from
 dynamic management views, such as sys.dm_os_performance_counters,
 sys. dm_os_memory_clerks, sys.dm_exec_requests, etc. no overhead 
is added to monitor the performance. To be able to query these views,
 the SQL Server login must have the VIEW SERVER STATE server
 permission. 

• Edited by VIMD Sunday, May 17, 2015 3:00 PM

Memory utilization reaches 90 to 95%. Even if its not peak hours still utilization is the same and it doesnt refresh. Please suggest.

Memory utilization reaches 90 to 95%. Even if its not peak hours still utilization is the same and it doesnt refresh. Please suggest.

That is pretty much normal. This is how SQl Server memory behaves it would take as much memory possible to cache as muh data and index pages to avoid physical reads.

Have you set max server memory?

Frankly 4 G RAM in current times is much less. I have no idea about workload but this is least a memory people keep these days on TEST machine. Production servers these days have atleast 6 G. You should consider increasing max server memory

Memory utilization reaches 90 to 95%. Even if its not peak hours still utilization is the same and it doesnt refresh. Please suggest.

I understood from your original post that you are having problems on the server, but the memory utilisation is a false lead. SQL Server will normally grab as much memory as you can. It will only yield memory if there are other applications that want the memory. Given the limited amount of memory on the server, I hope that there are no other applications....

Did you post the output from "SELECT @@version"?

yes server has RODC (read only domain controller) installed on the server.

SQL Server on domain controller is nothing which is recommended....

Team i getting error message while installing SQL on RODC server. Please advice