SQL Server Performance Forum – Threads Archive
How much space should be on C driveC drive holds page file and all program files… When do I have to put threshold for the c drive is too small I am thinking if it’s less than 10% of total c drive capacity AM I right?
dont understand the question. Page file does not necessarily go onto C drive, seems an obvious choice with a raid set up but if you have lots of high speed disk, it may benefit from being there instead
In general C: drive holds OS related files and utilising the page file on a SQL server will give a performance hit so ensure you have enough physical memory for the workload. Better to keep it on own array, otherwise leave it on C: drive. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.