Log shipping flushing the buffer...??
So the cache is building up for 30mins (up to about 6.5GB) then flushes again, obviously this will affect performance but i'm stumped as to what or why this is happening.
Is this something redgate have in their sqlbackup extended stored procedure??
The process basically kills all users in order to get exclusive access to restore the log and loops through all databases. I thought it may have been the killusers part but tested that and it doesn't seem to flush.
SQL Server 2005 Std (9.0.4226) - 2x Quad Core, 8GB RAM
Windows Server 2003 Std SP2