It may leave you wondering why your queries with complex joins and sorting operations are not producing results as fast as expected. Needless to say, if TempDB is not configured optimally, it can lead to operational bottlenecks and a degradation in performance. objects required by internal system processes.temporary objects triggered by user requests. In other words, your SQL Server instance recreates TempDB every time it restarts – giving itself a clean scratch pad with which it can work. TempDB is a significant cog in the overall SQL Server apparatus and as a temporary workspace – the data it holds is transient in nature. As the name suggests, TempDB is a temporary workspace required by SQL Server for creating and holding intermediate and temporary objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |