Windows

SQLIO

You’ve spent thousands on a shiny new server. Before you go ahead and configure your database environment, now is a good time to tune the software side of your storage subsystem for optimal performance. SQLIO is a Command Line IO benchmarking utility for Windows which can help you do just that. For Linux, consider utilities such as fio or bonnie++.…

Missing Sql Server Startup parameters

I once came across an issue with a local SQL Server instance that refused to start on my laptop. The Windows Event viewer reported ‘initerrlog: Could not open error log file ”. Operating system error = 3(The system cannot find the path specified.).‘ At the time I searched around on the net but couldn’t find any thing quick so I…