November 19, 2007 at 6:02 am
Greetings,
I am almost sure of the answer, but I want to be very sure: Can you profile (SQL Server Profiler) a filegroup?
Another question; The name of a datafile has no importance if you can profile a filegroup. right?
Thank you
MBA
MCSE, MCDBA, MCSD, MCITP, IBM DB2 Expert, I-Net+, CIW
Proud member of the NRA
-Anti-gun laws prevent law abiding citizens to buy guns and defend themselves against bad guys who do not care about the law and get their gun illegally.
- Democracy is 2 wolves and one sheep talking about their next dinner. Freedom is 2 wolves and one armed sheep with a .357 magnum talking about their next dinner.
November 19, 2007 at 6:43 am
The only thing I'm aware of that you can do by default is monitor file growth & shrinkage through Profiler. Maybe if you created a custom counter, but I'm not sure how to do that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply