I am contributing to the effort of optimizing our SQL 2000 server where I work. The downside is--I'm a novice (but quickly learning) when it comes to SQL 2000 tuning. One of the areas that I want to ...
This topic provides details about the configuration and use of the tempdb database in SQL Server and Azure SQL Database. Each internal object uses a minimum of nine pages: an IAM page and an ...
I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.<BR><BR>I honestly don't ...
The threshold of tempdb_data_size(Microsoft.Sql/servers/databases) is 80. it means 80kByte as tempdb_data_size. looking at storage(Microsoft.Sql/servers/databases) is ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback