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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Heavy Blockings

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
  Hi, There is a huge blockings on my Production server. When i run sp_who2  i could see many spid's are involved in these blockings. It is difficult to check the command for each and every SPID (around 30- 40 spid's) using dbcc inputbuffer and to find the root blocker. Is there any logic or query/procedure to find out the root blocking spid.   Regards, Sandhya  

View Complete Post

More Related Resource Links

Designing a heavy page



What should be the approach while designing when you know that your page would take considerable time to load? e.g. if it has controls which are heavy & some which are lighter? Can we make use of any of the design patterns to solve this issue?

how to make website that response even on heavy traffic load..

hi..i wanted to know that how to make the website that performance never goes down even if the load is increased up to some extent rather than the general websites.i am confusued that is this related to the database server or the coding...can i solve problem using multihtreading...please help me..

viewstate too heavy around 2MB

i am developing a a web application of a general store where the operator has to enter the things what cutomer has purchased.. like daily useage item,or anyhing .. so i have form in which i first ask how much item u wanna regsiter...(if he has 20-30 number of items then operator will eneter 20-30 then in gridview 20-30 item are opened... with bind dropdownbox containing name of item ,then textboxs containing mrp,value,stock avail of that item . here is the link for demo... http://iconsoftech.com/mahajan/grid/gridview_test.aspx problem is suppose the operator enter the value above 20.. then then viewstate size id about 1.50Mb thats too heavey please suggest me solution for this problem..<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridview_test.aspx.cs" Inherits="gridview_test" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Label ID="Label4" runat="server" Text="Enter No. Of Products"></asp:La

SSAS for heavy network data to serve around 12-15 million rows per day


I am a fresher with the analytics.

Presently, working on a system which tracks the data from Network giants like Bing, Google, Yahoo, Facebook etc. depending upon the profile of customers using our system.

So we our tracking data of around 5-6 million rows in a day. Apart from that, dimensions like Search Keywords and all also contain data of around 50-60 million of rows. Although, daily addition will be low in dimension tables, but it will keep on increasing as customers will increase. Tracking data is expected to grow beyond 15 million.

To provide analytics, I must have minimum of 3 months of data in a cube. To provide trends, it should increase to around 1-4 years (in our future road map).

Presently, I am suffering with fatal issues while processing a cube, like, "The operation cannot be completed because the memory quota estimate xxxx exceeds the available system memory yyyy" - while processing dimensions

Please guide with some good thought process how to manage such a huge data and provide analytics over it. As well throw some light over the approach to follow for testing cubes and data loading packages of ssis.

Please provide the links of articles/videos/blogs & name of books to discuss and decide design the analytics for data-extensive systems. Any kind of reading mater

I know this is not the right place because I have heavy problems with windowsclient.net and not with


... help me!

I was already trying to get support for my problem through sending mails and mails and mails over the contact section on windowsclient.net. But unfortunately I did not get any reply. So please be graceful with me, that I try to get help over this channel.

My problem is that I am unable to get access to my blog on windowsclient.net. The reason is I cannot sign in. When I try to sign in using the dialog that appears after I click on "Sign In" I don't get logged in. No error message nothing. I sign in with correct data but don't get logged in.

So ... could someone be so kind to provide me some help on this. It is a really big problem to me, especially because I cannot moderate my blog comments and cannot post new articles etc.



Show wait form while loading another heavy form


Dear All,

I have a situation in my project that is a small and nice popup with loading animated gif should show while loading heavy forms in the application. For that to implement I have used threading concept. I am opening loading splash form in a separate thread and ending it when the main thread notifies that its task is completed. Every thing is working fine but my problem is when the user clicks on the application's forms while splash screen is doing its business the application is hanging.

Please help me on this.The code is as follows

class PleaseWait : IDisposable
        private FrmSplashWait mSplash;
        private Point mLocation;
        private string ttlTxt;

        public PleaseWait(Point location,string ttl)
            mLocation = location;
            ttlTxt = ttl;
            Thread popupthread= new Thread(new ThreadStart(workerThread));

Clustered index gives rise to heavy transaction logging


We recently started purging old data from a table in our production system.  Since then we have experienced excessive transaction logging, system has gone from about 1-3MB every 15 minutes to 5-800MB in the same time with the same number of inserts (data rarely seems to change in this table). 

Table has a clustered index on an ID integer column that automatically increments by 1 for each new record. 

The purging of data is based on a column containing the time of insert plus a status column, so there could be IDs with low values remaining.  The purging job runs once per day and initially removed about 40% of the data in the table.  Now it removes one day every day and we keep a year of data.  The deletions do not seem to create more transaction logging than anything else.

Here are the column datatypes, note the column "data" (ouch) is of type image.  Design of table is from a third party and cannot be changed.

 [ID] [int] IDENTITY(1,1) NOT NULL,
 [jobindex] [nvarchar](100) NULL,
 [sortindex] [nvarchar](100) NULL,
 [metadata] [nvarchar](1000) NULL,
 [data] [image] NULL,
 [readflag] [int] NULL,
 [intjobid] [nvarchar](50) NULL,
 [extjobid] [nvarchar](50) NULL,
 [status] [nvarchar](50) NULL,
 [index1] [nvar

How to properly write thread heavy application?




I'm new to multithreading concept. I've searched for examples in books and on the net, but all I found are examples where threads aren't doing anything, they just sleep for few seconds. And from that I can't really learn anything good. Moreover, they don't quite say how to implement lots of threads, only how to move heavy load on separate thread. So few guidelines from you guys would be great.

I've been working on a small project, making a program that draws a color swatch. When the code runs on a single (main) thread, it takes about 6-7 seconds to finish, but what I want to achieve here is to break the CPU-intensive code into several parts and assign it (up to) 12 threads. Hopefully, this will get the job done much faster on multi-core CPUs.

Here's the XAML part:

<Window x:Class="MainWindow"

Doing heavy (application general) work in background



I'm looking for general guidance in a specific task I've been struggling with for a while. I'll try to describe the project in a simple manner:

I have a site that, in it's Page_Load function, checks the Application state for a variable holding some information. This information is changed about every 5 minutes or so. However, fetching that information is quite heavy, and makes the page freeze. Therefore I implemented an asynchronous timer, which made the heavy computation run in the background, when the user was already on the page. In that background operation the Application state variable was set, and could then be used in the next Page_Load(and for all other visitors coming to the page). The timer is frequently called, but the heavy computation is only performed every 5 minutes or so. The problem is that if the user enters the page exactly at this 5 minute interval, and tries to navigate on the site when the background operation is currently running, the site freezes until it's done. 

So, the basic question here is, how do you best perform heavy operations that produces a result general for the entire application? I've been thinking of other ways to thread the application, and I've been thinking of a web service (though I have no experience of services). As the information is general, only one user needs

Is moving heavy processing off of my webserver to a separate service helpful?



 I currently have some operations that require some very heavy processing...database calls, logic, etc..  Currently, this processing is being done on the webservers so a request may take a little while to complete.  I'm wondering if I were to take these processes off of the webservers and move them to another set of services if this would be helpful in any way?  Instead of having the webserver do the processing, the webserver would call (synchronously via wcf or soap) into another service to do it, then return the response.  What happens to the webserver during a synchronous call to another service? would it free up some processing power to allow the webserver to handle other requests in the mean time while it is waiting for the heavy process to complete?  Any info or additional thoughts would be greatly appreciated. 

Thanks in advance,

-Ryan van der Kooy

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