SQL-server profiler is a tool used to capture, analyze and save data about an event.
However the use of Profiler on a production Environment is HIGHLY NOT RECOMMENDED.Hence the use of profiler will be by deafult accessible to those users who has sys-admin rights only.
However there might be times where you need to provide profiler access to some of the developers working on SQL-Server environment's
The information contained in this website is for general information, Educational and Practice purposes only. The information is provided by .Raghuveera.com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk.
In no event will we be liable for any loss or damage including without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website.
Through this website you are able to link to other websites which are not under the control of [business name]. We have no control over the nature, content and availability of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them.
Every effort is made to keep the website up and running smoothly. However, [business name] takes no responsibility for, and will not be liable for, the website being temporarily unavailable due to technical issues beyond our control.
The below script helps in configuring a users account to have access to profiler.
Use Master; -- Master database because mastr has all login configurations GRANT VIEW SERVER STATE TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna]; GRANT SHOWPLAN TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna]; GRANT ALTER TRACE TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna];
Reading query plans (.........coming soon)
Tools (.........coming soon)
Pivoting (.........coming soon)
Real time data generation (.........coming soon)BLOCKING