Post reply

Testing hardware for SQL Server

  • May 8, 2018 at 9:40 am

    #345049

    Hello there,

    I have a couple of doubts about what tests i should do on a hardware before installing SQL Server and starting to create databases in it.

    You guys recommend running MSFT software SQLIOSim or Diskspd.exe on all of the LUNS, Physical disks on the hardware which will be used to create databases?

    I've been having a couple of Error 824 in my computer(nothing important lol)  and after reading and reading i found the tools mentioned above and my hard drive was in fact damaged.

    What's the next step in a production environment if one of these errors corrupts the database?

    Error 824 according to Microsoft

    2009-11-02 15:46:42.90 spid51      Error: 824, Severity: 24, State: 2.
    2009-11-02 15:46:42.90 spid51      SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:43686; actual 0:0).
    It occurred during a read of page (1:43686) in database ID 23 at offset 0x0000001554c000 in file 'H:\MSSQL.SQL2008\MSSQL\DATA\my_db.mdf'.  
    Additional messages in the SQL Server error log or system event log may provide more detail.
    This is a severe error condition that threatens database integrity and must be corrected immediately.
    Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

    Any other tasks before installing SQL Server in a production hardware?

    thanks!

  • May 8, 2018 at 10:16 am

    #1989732

    If you get 823/824/825, you likely have some hardware/driver issue. You should really stress the system, especially storage, and use HammerDB, SQLIO, something to be sure you have everything working.

    If you get corruption in production, better make sure you have backups to restore from. The fix could be as simple as drop/create an index or it could be a problem in a table. In that case, you might be restoring from a backup

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply