PROFILER is very handy tool to trace the events on SQL Server, like wise SQL Server 2008 gets the new feature Extended Events which is a light-weight & less intrusive tool. Still there are number of DBAs out there are really scared to invoke PROFILER on a production environment, the impact of running this tool for longer time is high and it is also very important tool for DBA to see what exactly is happening on server side. This is where a server side trace is very handy perform a server-side...(
read more)
No comments yet, be the first one to post comment.