Search Results

Search found 26 results on 2 pages for 'sqlprofiler'.

Page 1/2 | 1 2  | Next Page >

• Is a SqlProfiler Scan Started bad?

  - by Lieven Cardoen

  If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is?

  Read the article

• Is this a bug in Profiler or Entity Framework?

  - by AjarnMark

  Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database (ID = 8). The procedures execute properly and…

  Read the article

• TempDB is Full Issue for SQL Server 2000

  - by Jason N. Gaylord

  Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running SQL Profiler, but when running it, it…

  Read the article

• Unit of Measurement for Duration Column in Sql Profiler

  - by Mubashar Ahmad

  What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time spid=163 duration=11310646 starttime=2010-04-06 17:45:24.480 endtime=2010-04-06 17:45:35.790 reads=152 writes=2 cpu=16 eventclass=12 textdata= DELETE FROM dbo.[Icon] WHERE…

  Read the article

• SQL Profiler: Read/Write units

  - by Ian Boyd

  i've picked a query out of SQL Server Profiler that says it took 1,497 reads: EventClass: SQL:BatchCompleted TextData: SELECT Transactions.... CPU: 406 Reads: 1497 Writes: 0 Duration: 406 So i've taken this query into Query Analyzer, so i may try to reduce the number of reads. But when i turn…

  Read the article

• Where can I find SQL Profiler 2005?

  - by Kevin

  Is there a way to get the profiler without installing SQL server? If the answer is no, which edition do I need to get the SQL Profiler? Do I need the Developer Edition?

  Read the article

• Sql Profiler Scan Started to execute a stored procedure

  - by Lieven Cardoen

  Does SqlServer has to start a Scan to execute a stored procedure? In Sql Profiler I can see this: RPC Starting ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' ) Scan:Started Scan:Started Scan:Started RPC Completed ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' ) Can I somehow see…

  Read the article

• Capture query results using SQL Server Profiler

  - by SDReyes

  It's possible to capture a query's result using SQL Server Profiler?

  Read the article

• How to get SQL Profiler to monitor trigger execution

  - by firedfly

  I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace…

  Read the article

• Where can I find Microsoft Sql Profiler 2005?

  - by Kevin

  Is there a way to get the profiler without installing Microsoft Sql Server? If the answer is no, which edition do I need to get the profiler? Do I need the Developer Edition?

  Read the article

• How can i look at executed queries?

  - by taiga

  Hello, can anyone tell me how to view executed queries in SharePoint? I couldn't find a way to show query logs with SQL Server. As you know, SharePoint framework hides all queries from programmers. I would like to look into the queries and understand the mechanisms. http://www.infoq.com/articles/SharePoint-Andreas-Grabner In…

  Read the article

• In SQL Server, how to move/import a multiple .trc files to a trace table

  - by frankadelic

  I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO trace_folder FROM::fn_trace_gettable('C:\mytrace.trc', 4) However, this only appears to load the first file, not all four.

  Read the article

• Running SQL Profiler in the background

  - by cfdev9

  I want to leave sql profiler running all the time logging any queriy that runs for longer than 5 seconds. It's simple enough to start this using the profiler tool on my PC but how do I create it so it runs in the background on the server?

  Read the article

• Can profiler templates be migrated to newer versions of SQL Profiler?

  - by EBarr

  Is it possible to migrate Profiler templates to newer versions of SQL Server? In my case I want to take my SQL 2008 templates to 2012. I've tried (1) a straight file copy and (2) an export/import. In both cases the older templates run, but cannot be modified. Modifications result in the following error: I've got a…

  Read the article

• SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?

  - by chris

  I've used the SQL Profiler to generate a trace file, and tuning advisor to take that trace file and provide some recommendations on db updates. However, the SQL Profiler doesn't seem to track the queries when running against a Reporting Server, the profiler doesn't seem to be capturing any of the queries. I'm logging the…

  Read the article

• Show Detailed Error in SQL Profiler

  - by AlwaysBeCoding

  Is there any way showing the detailed exception for String or binary data would be truncated. I use LINQ to SQL and i cant figure out which column is that!? Tried numerous things but i get the same meaningless error i got from within Visual Studio. Also I use .NET 3.5 SP1, but errors are still returned useless.

  Read the article

• SQL Server Express Profiler

  - by David Turner

  During a recent project, while waiting for our Development Database to be provisioned on the clients corporate SQL Server Environment (these things can sometimes take weeks or months to be setup), we began our initial development against a local instance on SQL Server Express, just as an interim measure until the…

  Read the article

• Why Could Linq to Sql Submit Changes Fail for Updates Despite Data in Change Set

  - by KevDog

  I'm updating a set of objects, but the update fails on a SqlException that says "Incorrect Syntax near 'Where'". So I crack open SqlProfiler, and here is the generated SQL: exec sp_executesql N'UPDATE [dbo].[Addresses] SET WHERE ([AddressID] = @p0) AND ([StreetAddress] = @p1) AND ([StreetAddress2] = @p2) AND …

  Read the article

• CodePlex Daily Summary for Monday, December 13, 2010

  CodePlex Daily Summary for Monday, December 13, 2010Popular ReleasesRequest Tracker Data Access: 1.0.0.0: First releaseMicrosoft All-In-One Code Framework: All-In-One Code Framework 2010-12-13: Improved and Newly Added Examples:For an up-to-date code sample index, please refer to All-In-One Code Framework Sample…

  Read the article

• CodePlex Daily Summary for Wednesday, December 15, 2010

  CodePlex Daily Summary for Wednesday, December 15, 2010Popular ReleasesTweetSharp: TweetSharp v2.0.0.0 - Preview 5: Documentation for this release may be found at http://tweetsharp.codeplex.com/wikipage?title=UserGuide&referringTitle=Documentation. Note: This code is currently preview quality. Preview 5…

  Read the article

• CodePlex Daily Summary for Monday, March 14, 2011

  CodePlex Daily Summary for Monday, March 14, 2011Popular ReleasesProDinner - ASP.NET MVC EF4 Code First DDD jQuery Sample App: first release: ProDinner is an ASP.NET MVC sample application, it uses DDD, EF4 Code First for Data Access, jQuery and MvcProjectAwesome for Web UI, it has Multi-language User…

  Read the article

• CodePlex Daily Summary for Thursday, March 17, 2011

  CodePlex Daily Summary for Thursday, March 17, 2011Popular ReleasesLeage of Legends Masteries Tool: LoLMasterSave_v1.6.1.274: -Addresses resent LoL update that interfered with the way MasterSave sets / reads masteries - Removed Shift windows since some people experiencing issues If your interested…

  Read the article

• CodePlex Daily Summary for Wednesday, March 16, 2011

  CodePlex Daily Summary for Wednesday, March 16, 2011Popular ReleasesuComponents: uComponents v2.1 RTM: What's new in v2.1? 5 new DataTypes JSON Datasource DropDown Multiple Textstring Similarity Text Image XPath DropDownList Please note that the release of DataType Grid has been postponed…

  Read the article

• CodePlex Daily Summary for Friday, March 18, 2011

  CodePlex Daily Summary for Friday, March 18, 2011Popular ReleasesCraig's Utility Library: Craig's Utility Library 2.1: This update contains the following functionality additions: Added Min and Max functions to MathHelper Added code for handling comments to BlogML code. Added WMI based file…

  Read the article

• CodePlex Daily Summary for Tuesday, March 15, 2011

  CodePlex Daily Summary for Tuesday, March 15, 2011Popular ReleasesPhalanger - The PHP Language Compiler for the .NET Framework: 2.0 (March 2011): Phalanger 2.0 (March 2011) Release with Visual Studio 2008 integration. You can install additional managed MySQL extension to improve the…

  Read the article

1 2  | Next Page >