sql-server-profiler
How do you view Entity Framework calls in SQL Server Profiler?
I have a project that utilizes Entity Framework.I want to run SQL S开发者_如何转开发erver Profiler to see how many calls are being made to the database.I\'ve enabled almost every different event possi[详细]
2023-02-22 06:32 分类:问答SQL Server Profiler showing EF queries against master database?
What am I missing here? The queries I see in SQL Server Profiler are all targeted against the master database, which makes it difficult to filter by database name ... which event or events should I be[详细]
2023-02-19 15:01 分类:问答Performance discrepancy in SQL Server Profiler between web query and the same query ran in SSMS
I have a query that takes ~20x as long for SQL server to execute when it comes from a web request, as it does from when the exact same query is ran via SQL Server Management Studio[详细]
2023-02-13 08:51 分类:问答LINQ-to-SQL - when does it access the database?
In my asp.net mvc 2 app I have an action which is rather data-heavy. I\'m using linq-to-sql for the queries, while using the repository pattern.[详细]
2023-02-09 13:37 分类:问答Why does LINQ to SQL generate multiple select queries?
I am using LINQ2SQL. I just noticed (in the SQL Profiler) that LINQ was generating multiple select statements for the below LINQ[详细]
2023-02-08 03:59 分类:问答capture flow of execution in SQL Server
I am very new to Microsoft SQL server. I am wondering if it is possible to capture a trace of the sql query on a database executed from an external program while ignoring the actions caused 开发者_C百[详细]
2023-02-03 18:21 分类:问答How do I run a SQL Server trace to start and end at specific times?
I found the recipe for creating a SQL Profiler trace. How do I set up something to have this trace start and end at specific times, can I do this with a management task??[详细]
2023-02-01 20:48 分类:问答SQL Server Profiler 2005: How to measure execution time of insert statement with trigger?
I want to measure the execution time (using I guess duration from SQL开发者_StackOverflow中文版 Server Profiler) of an insert statement that has an instead-of insert trigger on it.How do I measure the[详细]
2023-01-29 08:32 分类:问答Sql tuning advisor(accepting profile)
I have created sql tuning task for some query and executed it.After generating report,It recommends me to run the following command:开发者_开发技巧[详细]
2023-01-27 22:25 分类:问答How to dump an output from SQL Server Profiler 2008 to a CSV-like file
I am debugging stored procedures, and right now I am interested in what ran in what order and which which parameters as opposed to how fast things ran and what may sneak in between and cause a slowdow[详细]
2023-01-26 07:07 分类:问答