i have an SQL Server on a Windows server 2012 R2 Standard (64) with 32 Gigabytes of RAM running a have a free 150 Gigs Space on 1 Tera HD. The storage is located in a different drive which has enough space , Logs are also located on a different drive with enough space and also backups in a separate drive
Maximum server Memory on the SQL Server is the default 2147483647 and Minimum Memory per Query is 1024.
This machine has been working very well with no issues. last week friday we started experiencing slowness on the server and the following is what i observed when i was troubleshooting
1) Memory for SQL Server (MSSQLSERVER) service is 28985.2 MB
2) Event Log has been giving me the following message
AppDomain 2 (SSISDB.dbo[runtime].1) is marked for unload due to memory pressure.
SQL Server has encountered 12 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf] in database id 1. The OS file handle is 0x000000000000081C. The offset of the latest long I/O is: 0x00000000410000
SQL Server has encountered 30 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [G:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\templog.ldf] in database id 2. The OS file handle is 0x0000000000000E70. The offset of the latest long I/O is: 0x00000000203000
When my users use my system everythings just times out. i used sp_who2 to check running process i found none.
Did anyone had this issue before ?
Thanks
Thank you for posting at Dotnetfunda
[Administrator]