Active Oldest Votes. Improve this answer. I tried this and it didn't work for me. I still only have the Data Profile Viewer. Thomas Stringer Thomas Stringer I found that blog entry too but I can't get Management Tools Complete check box enabled. Setup program suggests that parent feature Basic Tools I guess was installed for a different version in my case it would be Express Edition and to upgrade that version, but I already did upgrade from Express to Enterprise. In the process I was offered the option to uninstall only the Shared components.
I did that and then installed them from scratch. This is about 2 hours process SQL Server Installer is doing something for a long time, both during uninstall and subsequent install. Tony I have heard of that before, I believe.
I'm glad you got it working now. In neither case do I get Profiler on my Tools menu. So you are saying that the R2 server must be upgraded from Express Edition. Is the profiler available in the start menu for ? Yes and no. Possibly Profiler didn't exist in ? Collectives on Stack Overflow. Learn more. Ask Question. Asked 12 years, 8 months ago. Active 7 years, 4 months ago. Viewed k times. I guess it was Express and not Enterprise after all right?
Improve this question. Peter Mortensen 29k 21 21 gold badges 97 97 silver badges bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Mitch Wheat Mitch Wheat k 42 42 gold badges silver badges bronze badges. I was looking this. But this tool has been mostly under utilized by the Database Administartors. But before that, it is necessary that one should know the terminologies used in order to learn the working of the Profiler without much difficulty.
The various terminologies used in the SQL server Profiler are event, event class, event category, trace, data column, template and filter. Event Class : Event type which can be traced is defined as the event class. Any number of categories can be used, even if there is only one trace. Examples for event category : Locks and stored procedures. Data Column : An event class attribute that has been captured in the trace is called as data column.
The event class values are present in the data column. Trace : Capturing the data depending on the filters, event classes and data columns that are selected is called as Trace. These traces are normally stored in the trace files and also in the database. Template : Trace's default configuration is defined as template. Between the same instances of SQL server, the templates can be exported, imported and saved. But, between instances of different SQL Versions, the templates cannot be imported.
Nine pre-created templates are available with the SQL server The default template is also known as standard template.
0コメント