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

Top 5 Contributors of the Month
Melody Anderson
Eminent IT
Post New Web Links

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

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


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.





venkat reddy

View Complete Post

More Related Resource Links

WPF get Type in Design time?

Well here is my problem i have a class that inherits UserControl (View) now i use this class instead of the UserControl and i need to get the type in some cases now this works great a run time .GetType() returns the right type (for example ShellView) but when running in design time (the wpf editor in Visual Stuido) .GetType() returns the base type instead of the type of the current xaml document... Example: public class View : UserControl { public override void OnApplyTemplate() { MessageBox.Show(this.GetType().ToString()); base.OnApplyTemplate(); } } My XAML: <local:View x:Class="WpfApplication2.Test" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:local="clr-namespace:WpfApplication2" mc:Ignorable="d" d:DesignHeight="300" d:DesignWidth="300"> <Grid> </Grid> </local:View> so in this case when i open Test in the designer i get a message saying View, but when i run the program i get a message box saying Test.. How can i get the right type in design time im totaly lost on this problem..

An unhandled exception of type 'System.Net.Sockets.SocketException' occurred in system.dll

Additional information: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respondThis error occurs when i was executing a vc++.net program implementing ICMP....Error occurs when executing this statement... iRet=st->ReceiveFrom(RecvByte,RecvByte->Length,SocketFlags::None,&senderRemote);How to solve this problem????

A first chance exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll

I've read a bit about this error and maybe I have nothing to worry about.  BUT ... my simple little app gets 7 of these before it even gets to the first Dim statement in the Class Form1!  I found and followed instructions on how to have the Debugger intercept these exceptions but it seems that they are not being intercepted.  I only know that they have happened because of the messages in the Immediate Window.  In the Designer all I have is 5 Labels and 5 TextBoxes.   Any thoughts on how I could get to the cause of these messages? Thanks,  Bob

Exception of type 'System.ServiceModel.FaultException`1' occurred in WCF library

Hi, While Throwing Custom Fault Exception, am getting the warning message as An exception of type 'System.ServiceModel.FaultException`1' occurred in IAuthentication.DLL but was not handled in user code But Fault Exception handled in Client Side Please let me know, How Can I suppress this warning? Regards, Ganesh

An unhandled exception of type 'System.Net.WebException' occurred in system.dll Additional inform

Hi , I am giving my functioon below. I am getting the error when  executing  "       streamInput = HTTPWebRequest.GetRequestStream                "   error is  An unhandled exception of type 'System.Net.WebException' occurred in system.dll  Additional information: The underlying connection was closed: Could not establish secure channel for SSL/TLS.  Sorry for my bad english  Private Function GetXMLMarkIntnlResponse(ByVal strRequest As String) As String         Dim HTTPWebRequest As HttpWebRequest         Dim HTTPWebResponse As HttpWebResponse         Dim Encoding As System.Text.UTF8Encoding         Dim byte1 As Byte()         Dim streamInput, streamOutPut As Stream         Dim strmReader As StreamReader         Dim strURL As String = "https://beta.triseptapi.com/9.0/vax.asmx"         HTTPWebRequest = CType(WebRequest.Create(strURL), HttpWebRequest)         HTTPWebRequest.Method = "Post"         HTTPWebRequest.ProtocolVersion = HttpVersion.Version11         HTTPWebRequest.C

Let the users know that something is being processed in the background as they wait for a long time



I have a listbox that contains a list of items. The user is required to pick the items from this listbox and add them to another which is called selected items listbox. When doing this he needs to check for any duplicate entries as teh available listbox can contain duplicates but not the selected items list. I have 2 buttons "Add" and "Add All" to add items from available to selected list. The code for Add All button is:




DataFormatString for time only data type


I have a Gridview w/ the following fields:

<asp:BoundField DataField="StartDate" HeaderText="Start Date:" SortExpression="StartDate" DataFormatString="{0:d}" /> 

Unsure what high values for this wait type mean

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

ms sql data type when to use... and which time



I want to know what are the ms sql datatype and when to use..

Its very important when to use all the ms sql datatype

Waiting on processors eats processor time!


I have an unusual situation going on right now, which is giving me a chance to get some unusual views of the guts of SQL Server.  I'm wondering if what I see is known, is a feature or a bug, or if I shouldn't believe my lying eyes!

What I have is a situation where an app developer is accidentally (harumph) submitting some impossible cartesian joins to the server, and letting them run for an hour before noticing or killing them.  Fun to start with, right?  But here's the thing.  We have four processors and maxdop=0.  These queries generate parallel plans.  So what happens is the first one in grabs all the processors and runs forever.  Sometimes smaller queries leak through, somehow.  I'm not sure how that works!  But here's the thing, there are two more cartesian joins already running also, only ... they aren't really running.  They are consuming CPU time steadily, but doing no logical IOs.  I presume what is going on is that they can't reserve all the processors they need for their plans, and so are "resource starved" blocked, which does NOT show as blocked on things like sp_who2.

So, my question is, if they're just sitting there resource blocked, and the cpu times are running up fast - is that a bug?  Or are they actually maybe doing something useful with all that CPU, that does n

An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught


When the Stored procedure is executed through SQL Server Management Studio, its taking 23 seconds

When the same Stored proc is called through web app, its throwing below copied exception. It is noticed that when the data is more than 100k records this exception is thrown other wise expected records are shown in UI. Another stored proc from the same app returns over 150k records without any excetpion.

Can't conclude that the exception is in Stored proc, because it works from SQL Server Management studio, but throws below exception from Web app.

Your help is appreciated in resolving this issue.

An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
10/17/2010 16:56:01
Type : System.Data.SqlClient.SqlException, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source : .Net SqlClient Data Provider
Help link : 
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 11
LineNumber : 0
Number : -2
Procedure : 
Server : XXXXX
State : 0
ErrorCode : -2146232060
Data : System.Collection

Error occurred in deployment step 'Add Solution': An object of the type Microsoft.Office.InfoPath.


While trying to deploy custom SharePoint workflow solution in VS 2010, along with InfoPath custom task edit form, I ran into the following error message.

Error occurred in deployment step 'Add Solution': An object of the type Microsoft.Office.InfoPath.Server.Administration.FormTemplate named xxx already exists under the parent Microsoft.SharePoint.Administration.SPFarm named xxx Rename your object or delete the existing object

How can I resolve this problem? I have did some research but none helpful so far.


Blog: http://convergingpoint.blogspot.com/

An unhandled exception of type 'System.StackOverflowException' occurred in WindowsBase.dll


i have .net 4.0 application in wpf . application is running fine but when i close the application by using exit button. it throws the exception after stopping the debugging. the exception is  "An unhandled exception of type 'System.StackOverflowException' occurred in WindowsBase.dll ".

the code in exit button is


 private void btnExit_Click(object sender, RoutedEventArgs e)


don't know from where it throws the exception and why ??

can you upload multiple documents (to a doc library) and set content type and meta data at same time

can you do this?  it doesn't seem like the dialogs support this functionality.  As an alternative i tried doing it in a grid type view after the fact but i couldn't get the grid view to show the content type, even worse, the grid view would let me add meta data to content types that didn't even have that column as long as it was in the view!!

asp DataGrid wont show time(7) type


 I need help in resolving this issue, my datagrid will display time column only if its datetime2(7) type but not for time(7). same issue with data type, it wont display only the date. i am not using column binding for formatting because i have multiple tables where a user chooses to view with a selection from a dropdownlist. so does datagrid not support sql 2008 new data types? or am i missing something here.

NetworkStream ReadTimeOut doesn't wait for the time out period



I am using the TCPClient and the NetworkStream classes to establish a TCP connection and read the data from the network.
The NetworkStream object is set with a time out of 15 sec. The intent is, if the stream can't see any data from the network within 15 sec,
it will throw an exception and return. Something like myStream.ReadTimeOut = 15000. I set this time out once in the beginning just after the TCP connection  and the NetworkStream are created.

Though majority of the times (70%) it behaves nice and waits for the time out period to expire before throwing the System.IOException,
other 30% of the times, it just doesn't wait 15 sec before throwing the exception. It doesn't even wait for 2-3 milliseconds before throwing the exception.

I verified this using another tool, wireshark to time and detect the traffic.

Is the NetworkStream object doing some kind of optimization? Or do I have to do anything special to make it to wait for 15 sec?


Tech Crawler


Cumulative wait time on server replies Spiked very high




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

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