SQL Server Hizmet vermeme veya SQL hizmeti durma sorunu

Merhaba ;
Öncelikle SQL Server tarafında giriş seviyesi bir bilgiye sahip olduğumu belirtmek isterim ve sizlerden aşağıda detaylarını belirttiğim sorunum ile ilgili yardımlarınızı rica ederim.

Intel E5-2620 2.0GHZ 6 core ve 40 GB RAM olan fiziksel sunucu üzerinde Windows Server 2012 Standart Edi. kurulu. Hyper-V rolü aktif ve bu sunucu üzerinde 2 adet sanal sunucum çalışmaktadır. SQL Server kurulu olan sanal sunucuda Startup RAM: 20480 GB, Min RAM: 8192, Max. RAM: 32000 MB olarak ayarlı ve 4 core CPU atanmış durumda. Sanal sunucu işletim sistemi Windows Server 2012 Standart, SQL Server versiyonu SQL Server 2008 R2 dir.

Gün içerisinde özellikle yoğun olan zamanlarda SQL Servisi start durumda olmasına rağmen client larda SQL Server yok veya erişim engellendi şeklinde bir hata alıyoruz. Network ile ilgili olabileceğini düşündük ancak sorunun yaşandığı zamanlarda ilgili SQL Server da network erişimi ile ilgili herhangi bir soruna rastlamadık. Performance Monitor ü kontrol ettiğimizde CPU' nun %99, RAM'in ise %98 ini SQL Server hizmetinin kullandığını gördük. SQL Server üzerine attach edilmiş toplam 11 database imiz var ve toplam boyut 30,3 GB dır.

Hata loglarını incelediğimde aldığım hatalı event id ler ;  MSSQLSERVER 701, MSSQLSERVER 17803, MSSQLSERVER 17189, MSSQLSERVER 18053 dir. 

 SQL Management arayüzündeki loglar da aşağıdaki gibidir.

Date,Source,Severity,Message

12/03/2013 11:05:47,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

12/03/2013 11:05:47,,Warning,[260] Unable to start mail session (reason: No mail profile defined)

12/03/2013 11:05:47,,Information,[129] SQLSERVERAGENT starting under Windows NT service control

12/03/2013 11:05:47,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent

12/03/2013 11:05:37,,Information,[432] There are 7 subsystems in the subsystems cache

12/03/2013 11:05:36,,Information,[339] Local computer is SUNUCU02 running Windows NT 6.2 (9200)

12/03/2013 11:05:36,,Information,[310] 4 processor(s) and 20480 MB RAM detected

12/03/2013 11:05:36,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is

12/03/2013 11:05:36,,Information,[102] SQL Server ODBC driver version 10.50.1600

12/03/2013 11:05:36,,Information,[101] SQL Server SUNUCU02 version 10.50.1600 (0 connection limit)

12/03/2013 11:05:36,,Information,[100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 1808

12/03/2013 10:55:47,,Warning,[098] SQLServerAgent terminated (forcefully)

12/03/2013 10:55:46,,Error,[382] Logon to server '(local)' failed (DisableAgentXPs)

12/03/2013 10:55:46,,Error,[165] ODBC Error: 0<c/> Unable to complete login process due to delay in opening server connection [SQLSTATE 08001]

12/03/2013 10:55:42,,Error,[382] Logon to server '(local)' failed (SaveAllSchedules)

12/03/2013 10:55:42,,Error,[298] SQLServer Error: 258<c/> Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]

12/03/2013 10:55:42,,Error,[165] ODBC Error: 0<c/> Login timeout expired [SQLSTATE HYT00]

12/03/2013 10:55:42,,Error,[298] SQLServer Error: 258<c/> Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001]

12/03/2013 10:55:40,,Error,[311] Thread 'JobInvocationEngine' (ID 2284) is still running

12/03/2013 10:55:40,,Error,[240] 1 engine thread(s) failed to stop after 30 seconds of waiting

12/03/2013 10:55:10,,Information,[131] SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...

12/03/2013 10:12:08,,Warning,[135] AutoRestart: The MSSQLSERVER service was successfully restarted

12/03/2013 10:11:56,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...

12/03/2013 10:11:56,,Error,[012] The MSSQLSERVER service terminated unexpectedly

12/01/2013 07:58:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

12/01/2013 07:58:48,,Warning,[260] Unable to start mail session (reason: No mail profile defined)

12/01/2013 07:58:48,,Information,[129] SQLSERVERAGENT starting under Windows NT service control

12/01/2013 07:58:48,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent

12/01/2013 07:58:22,,Information,[432] There are 7 subsystems in the subsystems cache

12/01/2013 07:58:20,,Information,[339] Local computer is SUNUCU02 running Windows NT 6.2 (9200)

12/01/2013 07:58:20,,Information,[310] 4 processor(s) and 5500 MB RAM detected

12/01/2013 07:58:20,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is

12/01/2013 07:58:20,,Information,[102] SQL Server ODBC driver version 10.50.1600

12/01/2013 07:58:20,,Information,[101] SQL Server SUNUCU02 version 10.50.1600 (0 connection limit)

12/01/2013 07:58:20,,Information,[100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 1828

 Konu ile ilgili ne yapabilirim? 

İyi Çalışmalar.