What happens to my orphan Profiler traces?

Last week I was delivering a performance workshop to 10 people from different customers and one of them raised the following question: “Say that I’ve launched Profiler, pointed it to a given instance of SQL and set everything up to collect a given set of events/columns. For whatever reason, that instance of Profiler either crashes…

1

What’s in Enterprise only? (Database Tuning Advisor support for recommending Indexed Views)

If you want to leverage the ability provided by SQL Server Database Engine Tuning Advisor to evaluate what would be the benefit of creating indexed views as an additional physical structure, you can select either of the two tuning options available for such purpose: “Indexed views” and “Indexes and indexed views”. However, those two advanced…

0

What’s in Enterprise only? (SQL Server Audit)

Beginning with SQL Server 2008 you can set the database engine to automatically audit at several levels. All the tools and processes required to easily and successfully configure such flexible and comprehensive level of auditing, so that your system complies with whatever government or standard requirements your installation must adhere to, are available out of…

0

What’s in Enterprise only? (Fuzzy Grouping Transformation in Integration Services)

Fuzzy Grouping is a component which, when used as part of a data flow in an SSIS (SQL Server Integration Services) package, enables you to identify groups of records in a table where each record in the group potentially corresponds to the same real-world entity. The grouping is resilient to commonly observed errors in real…

0

What’s in Enterprise only? (Resource Governor)

You may have faced situations where you’d have wished you could avoid a run-away query consuming most or all CPU or memory shared resources of the server resources, or avoid the execution of unpredictable workload, or simply prioritize workloads so that resources are granted in a way that one workload is allowed to proceed faster…

0