kumargadu Posted April 10, 2013 Report Posted April 10, 2013 [color=#282828][font=helvetica, arial, sans-serif]C drive on my SQL server is almost full [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]C drive is 64 Gb ( in that pagefile.Sys is occupying 32 Gb , Any idea how to handle this ?[/font][/color]
techguru Posted April 10, 2013 Report Posted April 10, 2013 move the page file to second drive . you can move MSSQL data files to second drive, but that will be lot of work. change the page file location and restart the server
kumargadu Posted April 10, 2013 Author Report Posted April 10, 2013 [quote name='techguru' timestamp='1365606658' post='1303576964'] move the page file to second drive . you can move MSSQL data files to second drive, but that will be lot of work. change the page file location and restart the server [/quote] MSSQL data , program files anni seperate Drive lo unnayie , C drive lo only windows OS files and page file unnayie . Googling chesthey Page file multiple drives lo split cheyyochu ani undi kani performance emyna effect avutundo emo ani thinking
edisav_edava Posted April 10, 2013 Report Posted April 10, 2013 its not sql issue...contact ur sys admin....they know to move page file to another drive or add some more space....any case u might need to restart the server...is it windows server 2003?
kumargadu Posted April 10, 2013 Author Report Posted April 10, 2013 ok i will contact them , its 2008
edisav_edava Posted April 10, 2013 Report Posted April 10, 2013 i just got this info from my sys admin...if its 2008...u can move page file.sys to another drive on the fly..no need to bounce the server.... ask ur sys admin to do so
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts