Filter Sql Server Profiler by Database
Ok, I stumbled with this one enough times to log it here. I want to tune a database I’m working with. I dutifully fire up Sql Server’s Profiler, and no where in the options do I see “filter by database”.
Ok, the option is there, but it takes some doing to get there. When you’re building the profile, in the events selection tab, choose “show all columns”, then you’ll find the “Database Name” column. Pop in the database name in question, and you’re golden.