..., I have run the SQL Server Profiler to assist me in optimizing ...time of our business day. When I reviewed the location the tracelog was saved, there were 160 individual trace files. What I am concerned about is when I use the trace file in the Database Tuning Advisor,..., or will it analize one trace file at a time? If the...it possible for me to one trace file that collects data based on...
... calculation cycle that involves hundreds of SQL statements. The strange part is that...SQL statements and I am logging them to a file in sequential order. When I create a trace in SQLProfiler, I find some of the SQL staements are in a different order...to why this is happening in Profiler? Second.. This is only happening on... that is also hosting the SQL Server. Could machine speed and/or...
...developers could not load SQLProfiler although you had assigned ALTER TRACE permission to the logins. When you added...to the Active Directory user groups in SQL Server, but not each developer's domain...assigned it to the TestGroup; 3. Logged on SQL Server 2005, and added the ...: Use Master Go GRANT ALTER TRACE TO [MyComputer\TestGroup] Go 5. In...
...could not load SQLProfiler although you had assigned ALTER TRACE permission to the logins. When you.... They can't login with SQLProfiler and they can't import...the Active Directory user groups in SQL Server, but not each developer's...it to the TestGroup; 3. Logged on SQL Server 2005, and added the...: Use Master Go GRANT ALTER TRACE TO [MyComputer\TestGroup] Go 5....
Read up on "Server Side Trace". -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/...B9CA-6A3417F7CDEF@microsoft.com... Hello, How can I set SQLProfiler to capture the logs via command line? I wanted to this just before ... what I have: I already have a SQLProfiler Template (fooTemplate.tdf) which tells what I need SQL to capture. C:\>"C:\Program Files\Microsoft ...
...you can easily start a SQLprofilertrace to see where it ... user account to keep the logged data to the minimum. Linchi ... the wring forum. We have SQL Server 2005 that is managed ... his user account has started logging itself on, getting its privileges ... 6 entries in the security log); this is happening every 30 ... the consultant uses is the SQL Server. Is there anything within ...
... files as well. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "euDBA" <..., however I've used Sever trace and now have a multiple files ...I need to load the whole tracelog file into the table. ...useful in the future. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books ...
..., however I've used Sever trace and now have a multiple files...I need to load the whole tracelog file into the table. How can I do that in the... in the future. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books ... 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx ...
.... If the problem was ALTER TRACE, there would be a different message...> can see two possibilities: 1) Profiler fails to pass the required tokens... strange. I would imgagine that Profilerlogs like anyone else, that is... the command line? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books ...
.... If the problem was ALTER TRACE, there would be a different message...I can see two possibilities: 1) Profiler fails to pass the required tokens...very strange. I would imgagine that Profilerlogs like anyone else, that is...from the command line? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books ...
