Vipul Shah's SQL Blogs

SQL Server Blogs

Browse by Tags

Related Posts
  • Blog Post: Physical Database Storage Design and Disk Allocation

    The system page file should not be on the same physical spindle as any database files, otherwise you will not get optimum performance from the drive as its disk head will be jumping between the page file and the database files. Ditto for placement of log files and tempdb. Ideally you’d have page file...