Whatever transactions cannot be committed to the memory they would be forwarded to the disk subsystem by SQL Server. If one is hit, the other two take the load to try to bring the performance to acceptable levels, but there’s always the trade-off. Memory is one among the resources forming the performance triangle-CPU and storage being the other two.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |