Since SQL Server’s early days, there's been one notorious culprit capable of quietly—or spectacularly—crashing your environment: running out of space in TempDB. And let’s face it—that’s a ridiculous ...

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...

The local SSD drive attached to certain Azure Virtual Machines (VMs) provides optimized ephemeral storage. It's a high-performance disk that's physically connected to the host machine. The ephemeral ...

𝗧𝗲𝗺𝗽𝗱𝗯 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿: 𝗦𝘆𝘀𝘁𝗲𝗺 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗲𝘃𝗲𝗿𝘆 ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

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 ...

Mary writes for the programming section and has been doing so for the past two years. Her educational background is in Computer Science and Physics. SQL Server temp tables store data temporarily. You ...

, GrowthMb = (mf.growth*8.)/1024. , mf.is_percent_growth , MaxFileSizeMB = CASE WHEN mf.max_size > -1 THEN cast((mf.max_size*8.)/1024. as varchar(100)) ELSE ...

If your application uses the tempdb database a lot, and causes it to grow larger than its default size, you may want to permanently increase the default size of the tempdb file to a size closer to ...

This part describe the design of the environment. Article summary: SQL Server 2012-2014 AlwaysOn Availability Group For the tests, I will create an “AlwaysOn Availability Group” cluster with four ...