.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
AndyV
webmaster
SOHINI DASGUPTA
Post New Web Links

Displaying Execution Plans by Using SQL Server Profiler Event Classes - Filtering the trace?

Posted By:      Posted Date: November 25, 2010    Points: 0   Category :Sql Server
 

IN SQL Profiler you have the ability to see the execution plan for each query, which sometimes can be helpful. However, I'm not able to make use of any of my filters when profiling with the "Showplan XML" event class enabled.

Say, I want to sample only batches with a duration > 100 ms, how can I make this filter take effect? I have no problems with applying such filters when _not_ using these event classes.

I'm using SQL Server 2008.

Thanks.


Henrik F


View Complete Post


More Related Resource Links

Does SQL Server has the similar function just like Trace Event 10104 for hash join in Oracle?

  

My question is  how can SQL server display the  information about the buckets when doing the hash join just like the function of Trace Event 10104 in Oracle.By the way ,In Oracle ,the Event 10104 event dumps hash join statistics .
 
The buckets message what i needed is similar as the following,that is to say ,it must contains the information about buckets .
 
01 ### Hash table ### 
02 # NOTE: The calculated number of rows in non-empty buckets may be smaller 
03 # than the true number. 
04 Number of buckets with 0 rows: 16373 
05 Number of buckets with 1 rows: 0 
06 Number of buckets with 2 rows: 0 
07 Number of buckets with 3 rows: 1


Is there a way to configure a new SQL Server Profiler trace to be named same as name of the template

  
After I created a template and then use the template for a trace, most of the time I want the trace to be named same as or very similar to the template.   If SQL Server Profiler allows to copy the trace name, I don't mind to copy/paste but it does not.

Team System: Team Foundation Server Event Service

  

Use the Team Foundation Server EventService to create and manage event subscriptions or create a Web service to receive and process events.

Brian A. Randell

MSDN Magazine May 2008


Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer

  

In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005


C++ and ATL: Use ATL Server Classes to Expose Your Unmanaged C++ Code as an XML Web Service

  

Throughout this issue, you'll read all about the promise of Web Services and how the .NET Framework enables Web Service development. Many people will also be building their Web Services atop C++ code and frameworks like ATL Server, particularly when performance is paramount. In this article, the authors show how fully functional Web Services are built using ATL Server and Visual Studio .NET. Beginning with unmanaged C++ classes, they add ATL attributes that make the code work over HTTP.

Kirk Fertitta and Chris Sells

MSDN Magazine December 2002


Virus Hunting: Track and Report Server Attacks Quickly and Easily with the .NET Networking Classes

  

To help stop the spread of worms, viruses, and other hostile activity, it is important to track down and report the servers used in these attacks along with those used to send spam. Many Web administrators, however, don't take the time to track them because the manual process can be quite cumbersome. The Microsoft .NET Framework comes to the rescue with several networking classes, including the Dns class and the TcpClient class, that abstract away the complexity of performing DNS and WHOIS lookups. These classes make it easy to create a simple, straightforward ASP.NET-based utility for performing these lookups and automating this very important task.

G. Andrew Duthie

MSDN Magazine April 2002


Closing Javascript Modal dialog window after server side event processing

  

Hello Friends..


Please tell me how to close Javascript ModelDoalog Window.. after Server Side event Processing .

Basically i want close window in  finally Block After sucessfulll Updation.


AMit..... InnocentInnocentInnocentInnocentInnocentInnocentInnocent


Displaying the Server Ribbon and Site Actions Menu on Customized Search Pages Upgraded to SharePoint

  
Learn how to add the Site Actions menu and SharePoint Server ribbon to SharePoint Server 2007 search pages that you upgrade to SharePoint Server 2010 by using visual upgrade.

adding filter to sqldiag profiler trace

  
Hi everyone I'm wanting to create some standard diagnostics scripts for SQL Server 2005 installations and sqldiag seems the most logical way to do this. However, I want to be able to add filters to ProfilerCollector so that I can capture data for a specific database, application, etc. I've searched but can not find any information on either adding filters - which I suspect that you can not do - or specifying filters by using the template attribute.  However, Profiler itself does not seem to export templates as .xml which is the format of the default file specified for the template attribute! Does anyone know if adding filters is possible, by whatever mechanism, and if so does anyone have any examples?  It would be very much appreciated. thanks, and regards Simon

Triggering an event to occur within a VB.NET app if something is inserted into an SQL Server table

  
Let's say SQL Server is inserting arow within a table. Is there a way to let VB.NET know that an event was fired (being the inserting of the row within the table), without the need to query anything. Bascially having SQL Server tell the VB.NET app that an event was fired. It seems like it might be possible using CLR and the .NET framework integration wthin SQL Server, but I haven't found a sample program showing what I'm attempting. I understand that this topic covers SQL Server and VB.NET.  This need being for both and this forum only set for SQL Server, I thought I'd take the risk and post in this forum. Thank you in advance for any assistance.Newbie

Event 2436 - old application server cannote be crawled

  
DISCLAIMER:  I'm not a sharepoint admin...I inherited this after the former admin left...so be gentle. BACKGROUND:  We replaced at some point the original "application server" with a new one.  The old was called "fwmspapp" and the new is "fwmspapl"   I'm getting the following errors in the event logs on the new application server: Event Type: Warning Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2436 Date: 8/30/2010 Time: 9:50:03 AM User: N/A Computer: FWMSPAPL Description: The start address <sts3://fwmspapp:8270/contentdbid={083c7ae0-bc68-405e-a5e8-12eae72f1718}> cannot be crawled. Context: Application 'Search index file on the search server', Catalog 'Search' Details: The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. (0x80041200) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Followed by:   Event Type: Error Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2424 Date: 8/30/2010 Time: 9:50:03 AM User: N/A Computer: FWMSPAPL Description: The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again. Context: Application 'Search'

get url from server and fire event

  
i want to open new window ,but i dont want to provide url link in script because i want to hide this link from user.so is there any method to get URL from server and fire event to open new window after cliking button which has some server logic on that basis serever return URL. 

stop execution of client-side from server-side.

  
I have a textbox inside a composite control. I have exposed the textchange event to the page. In the server-side text change event, i need to show an alert box. So i m using ScriptManager.RegisterStartUpScript to raise the alertbox. My problem is the event is fired when any button in the page is clicked and they may execute some client-side script. I need to stop their execution. Anybody knows how to do this? Please help.

Cannot retrieve trace definition for SQL Server version

  
I am getting this error when I try to start  "New Trace" from Sql server Profiler. Cannot retrieve trace definition for SQL Server version 10.50.1600. Installation details Sql Server version : Sql 2008 R2 Developer edition Sql Management Studio, Profiler version : 10.50.1600.1   I referred this post http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e61b4800-bd69-4819-955a-e1c53594e1ef/ My registry looks fine. Any sugestions? Thanks.Thanks and Regards, Senthil | Stop Genocide in Sri Lanka | www.tamilsagainstgenocide.org

SSRS 2005 - Share Schdeule Execution Event?

  
Hi, I have SSRS 2005 and 10 different "Shared Schedules". Those share schedule has subscribed reports in it (i.e 5 reports in each Share Schedule). I would like to know when share schedule start firing execution event, does it execute all reports ONE at a time OR one-by-one like in queue? When I checked SQL Server Agent Job than it has only ONE step in it. Any idea? Thank You...  

SQL Server Event ID 17052: SQLServerAgent has terminated unexpectedly.

  
Hello All,       We are getting EventID17052 in one of our production server from last 3 months. SQL Server Agent is restarting on its own. As per threads about same issue I dig into the Jobs and processes running at that time in Server and I have found one job is causing this issue and Agent crash is happening same time that job is scheduled but not everyday. Server is running with SQL Server 2005 SP2 (Microsoft SQL Server 2005 - 9.00.3042.00 (X64)   Feb 10 2007 00:59:02   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) ).  Please let me  know is there any fix for this error and also let me know SP3 upgrade to SQL Server 2005 will help for it or not? I am also providing full error details from event viewer. The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: SQLServerAgent Monitor: SQLServerAgent has terminated unexpectedly. the message resource is present but the message is not found in t

not able to write log messages in event log on windows 2008 server

  
Hi, I am trying to write in Event Log on windows 2008 server with a windows service application. But I got this error: Service cannot be started. System.ComponentModel.Win32Exception: The parameter is incorrect at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type) at Siemens.SHS.Utilities.Common.LogManager.LogToEvent(String pLogName, String pSource, String logEntry, EventLogEntryType type) at Siemens.SHS.PEP.TaskCore.StartTask(String pPluginFilePath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.StartTasks() at Siemens.SHS.PEP.PlugnExecute.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)How can I write to Event Log on x64 platform as Windows 2008 server?Any help appreciated, thanks in advance,Cigdem
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend