Menu
Is there a SQL Server Profiler for SQL Server Expess? Maybe an open-source one? Or maybe just a tool that helps me see what query is passed to the database?
984
SQL Trace and SQL Server Profiler are deprecated. The Microsoft. SqlServer. Management.
SQL Server Express doesn't include SQL Server Agent, so it's not possible to just create SQL Agent jobs. What you can do is: You can create jobs "manually" by creating batch files and SQL script files, and running them via Windows Task Scheduler.
Click Start, point to Programs, click Microsoft SQL Server 20xx (your version), click Performance Tools, and then click SQL Server Profiler.
ExpressProfiler (aka SqlExpress Profiler) is a simple open source replacement for SQL Server Profiler with basic GUI. It supports both SQL Express and non-Express Editions.
SP1 of SQL Server Express 2012 Advanced Services now includes the full SQL Management Studio, and this has the profiler.
132
Ok, old question but maybe this helps other people with same problem.
You can activate the SQL Server Express Error Log in a way that it monitors all statements runned agaist every database. To do so you must run the following on an elevated command prompt (that is, a command prompt runned as administrator):
net stop MSSQL$SQLEXPRESS net start MSSQL$SQLEXPRESS /T4032 Now, using the SQL Server Management Studio run the following:
dbcc traceon(3605, -1) Now you can look at the ERRORLOG file within the Log folder of MS SQL folder (which may be "C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log" for the default installation of SQL Server Express 2012).
Hope this helps someone (as it sure helped me)
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
