Torsten Schuessler
Sapere aude! (aka tosc)
Sapere aude! (aka tosc)
A lot of features / tools are included with the SQL Sever 2005 Express Edition (GUI, Reporting Services etc.), but not all of them like the Profiler.
OK, you run a server side trace on your SQL Server Express databases as well as import the data into a table for analysis, but you don`t have a GUI Tool like Profiler - which is include in Standard or above.
...
But it may be an option to use this free tool SQL Server 2005 Express Profiler.
The SQL Server Express Edition Profiler provides the most of functionality standard profiler does, such as choosing events to profile, setting filters, etc.
So if you are looking for a free performance tool for SQL Server Express take a look at this tool. The source code is also available for download,-) - It is an open source project by AnjLab.
CU
tosc
| Print article | This entry was posted by Torsten Schuessler on 2008-03-22 at 00:28:28 . Follow any responses to this post through RSS 2.0. |
administration backup «best practices» books bug ctp «cumulative update» datetime denali dmv ebook humor index indexoptimize integrity kbfix links loginproperty maintenance «ms sql server 2008» performance php «reporting services» reviews «ross mistry» rtm serverproperty «service pack» «service packs» sharepoint sp_msforeachdb «sql 2012» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server builds» sqlcat «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql technet «technical note» tempdb tools troubleshooting version whitepapers
2010-10-25 @ 17:46:03
We just ran into an issue with a single query gumming up the works and had to install the profiler. Free = good....