Sql Bros , Need Help

[kumargadu]

[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]

[ghazni]

company laptop aa ni personal aa.....

[kumargadu]

Company Server vaayie

[techguru]

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]

[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]

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]

ok i will contact them , its 2008

[edisav_edava]

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