Tag: "tempdb"

Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014

Great KB article, with a lot of helpful guidance and information about configuration settings and valuable hotfixes for SQL Server 2012 and SQL Server 2014 used with high-performance workloads! Really good stuff! A huge list of categorized advice for… more »

Welcome as a Speaker for SQLSat 230 Rheinland

Yesterday, I received the "Welcome as a Speaker for SQLSat 230 Rheinland" – Mail. BANG! I am touched ... We are happy to announce the schedule for SQLSaturday #230 Rheinland and welcome you as one of our selected speakers. What an honor! I will talk… more »

Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY

I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts: How does DBCC CHECKDB WITH ESTIMATEONLY work (Paul) DBCC CHECKDB WITH ESTIMATEONLY: Do you trust it? (Ana) DBCC… more »

SQL Server 2012 Tempdb File Size Change tracked with Extended Events

We are using SQL Server 2012 and the tempdb is growing so fast. How do I effectively find what’s causing my tempdb growing. Can I monitor the file size change with Extended Events to find out the ... more »

Kostenloser PASS-Vortrag "Performance & Manageability der tempdb“ - 19.02.2013 - Nürnberg‏

 Hallo PASS‘ler, hiermit möchten wir euch zum nächsten Treffen der Regionalgruppe Franken in Nürnberg am  Dienstag, 19. Februar 2013,  18:30 bis ca. 20:30 zum  kostenlosen Vortrag Performance & Manageability der tempdb     Performance &am… mehr »

Automatische Vergrößerung der "tempdb"-Systemdatenbank

In MS SQL Server 2005 wird für die "tempdb"-Systemdatenbank mehr Speicherplatz benötigt als in früheren Versionen von SQL Server, dies kommt zu einem durch eine erhöhte Leistungsverbesserung , sowie enthaltender neuer Features zustande (siehe BOL… mehr »