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


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

Unsure what high values for this wait type mean

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 
We are in the middle of troubleshooting a slowness issue on a 2008 instance and I'm seeing the wait type of Dispatcher_Queue_Semaphore with a high wait value. I've been looking and haven't really found anything about this wait type. Does anyone have more information about this?
Big Ern


View Complete Post


More Related Resource Links

A time-out occurred while waiting for buffer latch -- type 2 Not continuing to wait.

  

Hi,

when we are executing query in sql server 2005(SP2) we are getting below error.

A time-out occurred while waiting for buffer latch -- type 2, bp 03BD8650, page 1:15883707, stat 0x1c0040d, database id: 7, allocation unit Id: 72057608604745728, task 0x54FA8118 : 5, waittime 300, flags 0x3a, owning task 0x009291F8. Not continuing to wait.

Physical Memory=8G.

Memory Utilization is also looking normal.

please let me know how to avoid this problem and provide me if any article is available.

 

Thanks

venkat

 


venkat reddy

Copy a doc accross with values from its content type

  

I have a workflow automation to copy a document from 1 site to the other . It works fine using the SPFile object. My concern
is the doc that is being copied from is a content type called Content1. Now how do I copy the content type values accross to the new area after the arrow sign ?

        
            // Source Site
            SPSite SourceSiteSP = new SPSite(SourceSite);
            SPWeb web = SourceSiteSP.OpenWeb();

            SPWeb SourceWeb = SourceSiteSP.OpenWeb();
            SourceWeb.AllowUnsafeUpdates = true;
            SPList lib1 = (SPDocumentLibrary)SourceWeb.Lists[subSite];
            lib1.ContentTypesEnabled = true;

            // Destination Site
            SPSite DestinationSiteSP = new SPSite(DestinationSite);
       

Determine node type selected in TreeView and reading property values

  

I am hoping that someone can help me get past some problems I am having when using the WPF TreeView control.  I have a TreeView that at most can have 3 levels.  The levels are defined as Project, Discipline, Person which would look like the following:

+ Project

    + Discipline

        - Person

My TreeView is bound to a database using two HierarchicalDataTemplate's and then one DataTemplate (the binding is done in the XAML).

What I would like to get is the following information when selecting an item:

  1. Read the selected value (text of the selected node)
  2. Is it possible to pass an array of values, or a custom type as a parameter?

      

    I am using a web service as a datasource.  When I create my report I would like to pass
    a string array to this web method to retrieve the data for the report.  Is this possible or is there
    a similar way to do this such as passing a custom type?

     

    thanks,

    buckaroov

     


Cumulative wait time on server replies Spiked very high

  

Hi,

 

We have a statement that we have identified as taking a long to run.  Previoiusly, it ran quickly.  The statement was created with the help of execution plan and all I/O and CPU numbers are very low (IE.  0.000032)  At the moment it has slowed down.  Checking out the statics we can see the process time is very small however, the wait time is HUGE.

 

Any ideas, advice, or suggestions as to possible causes?  It does appear that the CPU usage goes up when the statement is slow.  A reboot of the server has the statement running at its normal quick execution.

 

Application Profile Statistics

0       0         Timer resolution (milliseconds)
0       0         Number of INSERT, UPDATE, DELETE statements
0       0         Rows effected by INSERT, UPDATE, DELETE statements
1       1         Number of SELECT statements
39     39         Rows effected by SELECT statements
1       1         Number of user transactions
0       0         Average fetch time
0       0         Cumulative fetch time
0       0         Number of fetches
0       0         Number of open statement handles
0       0         Max number of opened statement handles
0       0         Cumulative number of statement handles

Stored Procedure multile values parameter with integer type

  

Hi,

I have created a store procedure with input paramenter @param1 of integer type to return result from a select statement as below:

SELECT * FROM TableABC WHERE columnabc LIKE (@param1)

the columnabc in the WHERE clause is of integer type.

I will like to be able to pass multiple values of integer to @param1, such as @param1 = 1, 2, 3.

Please advise how do I achieve that?

Thanks

Peiwai


TreeSelector : playing with generics and type inference

  
create a generic way to define a selection starting from a tree of objects, the most simpler way as possible.

Let's start with the beginning...
Here is a very simple little interface defining a node of the tree, basically, a value and the references to the child nodes.

ASP.NET Best Practices for High Performance Applications

  
This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

High-Performance .NET Application Development & Architecture

  
It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

High Performance ASP.NET - Speeding Up ASP.NET Pages

  
have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

10 Tips for Writing High-Performance Web Applications

  
Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.

UnTyped DataSets and Strongly Type DataSets

  
We all are use datasets as a means of carrier of data from one layer to another. Most of the time we are using weakly typed datasets. In this article I will explain the differences between weakly typed datasets and strongly type datasets

How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

jquery autocomplete multiple values

  

i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?

 


Gmail style multiple Sign-in type combo...is it possible in asp.net?

  

I am developing a multi-company application and want my users to give the functionality like the following to switch companies.

http://gmailblog.blogspot.com/2010/08/access-two-gmail-accounts-at-once-in.html

Is this possible? then how?

Please help


Thanks



JQGrid Loading deleted values

  

Hi,

This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.


Here is the code:


function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {
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