The tempdb is a system database which is available for all the users connected to that instance of SQL Server.
This database is used to hold
Below are some best practices that can be followed for tempdb
This database is used to hold
- Temporary User Objects
- Internal Objects created by the Database Engine
- Row Versions that are generated by data Modifications
Below are some best practices that can be followed for tempdb
- Create the number of data files for tempdb based on the number of CPU's present on that system. Example: if the system has 4 CPUs then create 4 data files for tempdb with one Log file.
- Place tempdb files on the fastest available Drive.
- Isolate tempdb on a separate disk from other databases.
- Make all the data files of tempdb the same size.
- Disable autogrow option for all tempdb files and make sure you have enough space in them.
- Make sure to Commit or Rollback the transactions and if not done, then any space allocated for that transaction may not be released.
2 comments:
please share the Tempdb issues and scenarios also
Đặt vé máy bay tại Aivivu, tham khảo
giá vé máy bay đi Mỹ khứ hồi
mua vé về việt nam
giá vé máy bay từ canada về Việt Nam
cách mua vé máy bay từ nhật về việt nam
ve may bay tu han quoc ve viet nam
Vé máy bay từ Đài Loan về Việt Nam
khách sạn cách ly
Chuyến bay cho chuyên gia nước ngoài
Post a Comment