SQL Server Requests Time Out As TempGetStateItemExclusive Getting Called Continuously
Jan 28, 2010
I run a site with decent traffic (~100,000 page views per day) and sporadically the site has been brought to its knees due to SQL Server timeout errors.When I run SQL Profiler, I see a command getting called hundreds of times a second like this:
We use SQL Server to store ASP.NET session state. The above is the stored procedure called to grab the session state for a given session. It seems to be looping, asking for the same 2 or 3 sessions over and over. I found a promising looking hot fix that seems to address this exact situation, but it doesn't seem to have solved the problem for us. (I'm assuming this hotfix is included in the most recent .NET service pack, because it doesn't look like you can install it directly anymore). I added that registry key manually, but we still see the looping stored procedure calls like above (requesting the same session much more often than every 500ms) I haven't been able to recreate this on a development machine. When two requests are made for the same session ID, it seems to block correctly, and even try to hit SQL until the first page releases the session.
I am want to develop a quiz site using MVC 2. A single page will display only one question. The examinee will select or type the answer and press Next button to proceed.
My business logic on the server side will record the time elapsed between two consecutive page requests. This time elapsed must not be tempered by any means to make a reliable diagnostic report.
we have this web service that sends JSON code to an iPhone application.
Each time the app makes a request, the web serice accesses the database, grabs corresponding xml data, transforms it to JSON code and then sends it back to the app.
the xml data gets updated approximately every minute, you can assimiliate this process with a sport app of which you can watch live game commentaries.
Now the iPhone app is going to implement a refresh button which a user can proactivly hit it against the service to fetch the latest data.
So we need to implement something that is capable of handling multiple requests that could occur at the same time or in a very short period of time.
I want to use a function in the code file of ASP.NET such that everytime the function is called, its value increases by 1.I thought of a way but it didn't fully work out. I created a class for this and used a static variable in that but the lifetime of static variable in asp.net is till the time the app does not close.
How code a time delay before the next method is called? I have the following but I don't think it's waiting 10 seconds before calling CallMethod(). Thread.Sleep(10000); CallMethod();
Using Forms authentication, for some reason my login page is called 9 times. it causes some browsers to show "too many redirects!". Even with no javascript and nothing in the page_load event, it is called 9 times.
What's the simplest and most effective way to selectively redirect HTTP requests to your ASP.NET page to its HTTPS equivalent? For example, if my page site URL is [URL], I want to redirect some (or all) page requests to [URL] What's the easiest way to do that?
I have a form which inserts data in DB on Submit button click but the problem is when client click the button multiple times its sends multiple create requests means multiple button click events for the same time of same data, which must not be.
I tried to disable the button when client click the Submit button first time but after this it does not call server click event handler or not fire the server click event once it got disabled.
I have a weird design. I have page called A, it has control called C1 which has a control called C1-1 which has a control called C-1-1-1. C-1-1-1 is inside a modal popup extender. Whenever their is a postback, the C-1-1-1 's Pre_Render is called twice, first with the correct values and parameters which seem right. And second with all values seemingly reset (sounds like a new object construction).
I am using asp.net and I would like to test a few hundreds concurrent requests to the same page, and get a result. I don't need it via browser. Just a tool that sends requests and prints the result Is there such tool?
We are creating a real estate website. The National Franchise site wants to pass us searchs that fall in out local area. The searches MUST follow this format:
Here's the big picture. We're running a server in IIS 6 that hosts several web sites and applications, and we're in the process of moving the whole thing to a different data center with a slightly different setup. We've notified our users and updated our DNS info so that theoretically everyone will be happily hitting the new server from day 1, but we know that someone will inevitably fall through the cracks.
The powers that be want a "Listener" page/handler that will receive all requests to the server and log the entire request to a text file, including (especially) POST data.
That's where I'm stuck. I don't know how to implement a single handler that will receive all requests to the server. I vaguely understand IIS 6 redirection options, but they all seem to lose the POST data on the redirect. I also know a little about IIS 6's built-in logging, but it ignores POST data as well.
Is there a simple(ish) way to route all requests to the server so that they all hit a single handler, while maintaining post data?
Is there a way to view incoming requests to a local ASP.NET development server? I'm making wcf service calls from a android app to a local development server. Something goes wrong somewhere along the way, and I need to view what data the server recieves.
Edit: The android app is local too... in an emulator.
I'm creating a very simple chat application. It has an ASP.NET web page as front-end and a WCF service as back-end for storing the messages to a database.Everything works great except one thing; when Browser A enters a chat message I want Browser B to see the message as soon as possible (yeah, I know, that's the purpose of a chat).What I've done so far is to setup a trigger within the UpdatePanel, like this:
Is this the best approach or is there a better, yet simple, way to accomplish updating of messages. One drawback with this solution is that the textbox used to enter chat messages loses focus every time the Tick event runs.
i want a continously running thread in my web application for sending mail to admin if the logged complaint of the user in not solved by technician within 24 hours.
i am able to send mail to administrator
i just want a watch on database for unsolved issues with timespan of more than 24 hours and inform to administrator about the same
I used the NuPack tool to add Elmah to a site on my developer machine. This worked like a charm, but when I send a request to the elmah.axd page all I get in return is 500 - Internal server error.
My code setup: Visual Studio 2010 Site built on top of EPiServer 4.62B Running on .NET Framework 2 (because of EPiServer)
My IIS setup: IIS 7.5 Classic .NET AppPool (because of EPiServer)
My computer: running Windows 7 32bit (because of EPiServer)
I'm working with asp.net c# web application. We have completed site and hosted in dedicated server (own server).
This server having only one site (sharepoint site). A page having 1000+ images. Loading in base page. And slide show in popup page.
Base page image painting is going on. At same time popup page image is not loading up to base page paint complete. I changed popup image download to some other server means working fine.
Here my problem is same domain more than 2 request web server (iis) not responding up to first 2 requests complete. We can call 2 requests at a time. How to increase more than 2 request in ie. This problem is not available in Firefox. Firefox can manage more than 2 requests. Ie not allows only 2 requests to one domain at a time.
How to send more than 2 requests from ie to a domain?
I am looking for the directions on how to set a report to printcontinuously, without a paper feed. I have set one up using the LabelWizard, but how do I set it up in an existing report? I have lookedthrough all the property settings and cannot find any reference to it.
Is it possible to store gridview session data after each postback. I have a gridview and a checkbox within. Each time a user clicks the checkbox, I like to store the gridview ID in a session. After browsing through various pages, I like this session datato continuously store the information up to 20mins?
How can I continously store the session variable. Say a text box and if I enter 1 click on a hyperlink (where session variable is stored) return back to the page, enter 2 click hyperlink then I should get in the session 12?
I use four different update panels, that use the same timer as trigger.
1) Will the 4 update panels create 4 different HTTP requests to the server? 2) I'm using 4 different panels as the controls are located in different parts of the page, is there a way of putting them in the same update panel? 3) Is this a good coding practice?
I am using ajax control toolkits and ajax extentions in my projects. and as you know it overhead some libraries to page. How can I combine them into 1 js file to reduce requests to server ???
I create a webcontrol (DefectsList as a gridview) with an icon that call an httphandler to open an other webcontrol (DefectEditor as an editor) but the CreateChildControls of the editor is not called!!
see the details below of DefectsList:
[Code]....
and the javascript: [Code]....
see the details below of DefectEditor: [Code]....
Why the CreateChildControls is not called, I think is due to the HttpHandler? so how to do?
I'm using Sqlreader to get some information from a database table. Right now I have it looping through a while loop, and adding in the appropriate information in to an asp table contol. I'm not haveing any difficulty with that, what I am having problems with is sorting the data. I just want it to sort it by a field called title. I tried putting an ORDER BY statement into my SQL command, but it throws an error saying it cannot sort a text field. So the only thing I can think of is instead of adding the data right from the sqlreader to the table control is that I first put it into an array, sort the array, and then add it to the table control. It seems like an ineffieint way of doing it. Is there a better way of sorting this stuff or is there a way to get the database to do it for me like with the ORDER BY command?
I have a stored procedure that I need to execute from asp.net button , It takes more than 30 mins to execute. So here I need to show a message like "In Process" while execution and disable couple of links..Once the execution is done I need to show "Last processed data and time" and enable the disabled links. So in "In Process" stage we have to allow user to access other pages in the site. How it is possible?
I want to know how to use auto refresh continuously in ajax update panel..What I want is,I've more than 6 update panels on my page and I want to all the panel to refresh toghether,continuously till I close the page.
