MSSQL and ramdrive (ImDisk ), bad idea…

I woke up in the morning and tried to optimize my MSSQL server. Simple optimization; since tempdb has quite a lot of traffic, I decided to move it to ramdrive.

USE master;
MODIFY FILE (NAME = tempdev, FILENAME = ‘Z:\SQLData\tempdb.mdf’);
MODIFY FILE (NAME = templog, FILENAME = ‘Z:\SQLLog\templog.ldf’);

AND this was a major failure…SQL server won’t start.

“An unexpected error occurred while checking the sector size for the file ‘Z:\tempdb\tempdb.mdf’. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information.”

To start SQL server and restore previous tempdb location. Step one: unmount ramdrive disk (Z:). Step two: mount USB stick with letter Z:. Then restart SQL server and restore tempdb paths.

Lisa kommentaar

Täida nõutavad väljad või kliki ikoonile, et sisse logida: Logo

Sa kommenteerid kasutades oma kontot. Logi välja /  Muuda )

Google photo

Sa kommenteerid kasutades oma Google kontot. Logi välja /  Muuda )

Twitter picture

Sa kommenteerid kasutades oma Twitter kontot. Logi välja /  Muuda )

Facebook photo

Sa kommenteerid kasutades oma Facebook kontot. Logi välja /  Muuda )

Connecting to %s

%d bloggers like this: