New answers tagged tempdb
You need to work with your storage vendor to figure out why the writes are being torn. If it's happening to tempdb it's very likely that it's happening to another database as well. This is especially true if it's happened more than once.
Thanks for your input. Actually i found it. Those tables created by one SP which is set to execute on start-up of database engine service and configured with SP_PROCOPTION system stored procedure.
They must have also been created in the model database. Anything in model gets created in any new database that's created (but not restored or attached), including tempdb on restart.
If your data needs to be persistent over a failure & restart then a "real" table in your database would be best. You need a mechanism to isolate one user's execution of this from another's and to tidy up nicely. If data is to be disposed of if the SP crashes and will be re-created on a restart then a table-valued variable would be adequate. These are ...
is there a risk that something can get corrupted regrading data and availability group listener No, tempdb is recreated when SQL server restarts. If your tempdb is large, Make sure to enable instant file initialization for data files only. The instructions are fine and follow the comment that I put in.(will add it in answer later)
Top 50 recent answers are included