{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 一夜七次 的问题《Is there a SQL Server Profiler for SQL Server Expr》','https://www.manongdao.com/q-93186.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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?
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- Entity Framework 4.3.1 failing to create (/open) a
- Profiling Django with PyCharm
- Code for inserting data into SQL Server database u
- Delete Every Alternate Row in SQL
- Linux based PHP install connecting to MsSQL Server
- SQL Azure Reset autoincrement
- How do we alias a Sql Server instance name used in
- Is recursion good in SQL Server?
Anjlab SQL Server Profiler is no longer free and it only worked on 2005 instances. I've wrote a basic SQL Server 2012 Profiler which works perfectly on 2012 Enterprise and 2005 Developer engine instances. You can download here
please give me your feedback.
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):
Now, using the SQL Server Management Studio run the following:
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)
SP1 of SQL Server Express 2012 Advanced Services now includes the full SQL Management Studio, and this has the profiler.
IIRC, the profiler is one of the features not available for SQL Server Express.
However, I'm also under the impression that SQL Server Express still supports many of the features of the for-pay editions, and it's just that they are disabled in the Express Edition of Management Studio. So if you also have access to a full db and the management studio that comes with you might be able to point that profiler at your express installation.
In this case I suspect that won't work, since the profiler also depends on an extra provided by the database. Still, it's worth a shot.
If it doesn't work there are some third party tools available that should be able to do what you want.
SQL Express Profiler will likely meet your needs. When this question was asked it was free, but it looks like it has recently changed to a paid license model.