SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events We are using SQL Server 2008 and the server has a lot of performance issues that seem to be related to a saturated tempdb database. TempDB on this server is heavily used by creating and dropping many temp tables and work tables. How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information pro
This demonstration will focus on the abilities of Idera's SQL Compliance Manager and Idera's SQL Secure as a comprehensive SQL Server auditing, security and alerting solution.
The presentation is geared for both the DBA or accidental DBA - whether you monitor a handful of instances or hundreds, the overview will show you how you can make better use of your time and life easier when it comes to your SQL Server environment.