PearlJammer1 (8/28/2014)
We use a third party to host our sql servers. All our data and log files are on separate discs - S for data, L for Logs.We use replication and on the Distribution server all the databases are using simple recovery model.
In the error log on that server I see:
SQL Server has encountered 1 occurrences of I/O requests taking longer than 15 seconds to complete on file : L[\Path to file\distribution.LDF] in database distribution
Where do the separate disks reside, I'm guessing they're not locally attached but provided by a storage area network.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉