I am working on some application. We are using Sqlserver2008. We dont have Sql profiler to trace stored procedure and all. We can't install also imidiately.
can anyone give some idea how to trace which stored procedure is hiting my Sql server.
Is there a profiler for sqlserver express 2008 R2 I can use? Is there anyway to trace the db commands without a profiler?I'm also using ms web developer 2010 express.
I would like to monitor all the queries running under Oracle which are being fired. Looking for some good UI tool for Oracle similar to Microsoft SQL Server Profiler.
I think I have a problem that I never noticed before. I was just recently (as in tonight) shown the SQL Server Profiler. I noticed that on a video that I watched there profiler did not move unless there was a query to the database, thus making it easy to see what exactly was going on. When I opened mine for the first time and ran it I am getting 9 logs every say 5 seconds. They consist of;
Does anyone know if this is normal or my database just working way to hard?
I just restarted the server and checked databases for active connections now that I know nothing is running, and found the one database that is causing the problem... ReportServer has 4 connections after my restart. Should I leave this alone? Is it normal to have this reporting constantly going on?
I'm using ASPxPageControl and in each page I have a couple of grids. When Im using Sql Server Profiler each time I change Tab there is a query for each grid in each tab sent to the database. Is it possible not to load data for each grid while changing tabs ?
I am trying to redirect my trace output to a text file.
For this I tried to add a textwritertracelistener object to Trace.Listeners.Add but I can't see Listeners Class in Trace.ie When I put Trace. the Listeners class is not popup. Also I am unable to add System.Diagnostics.TraceListener namespace to the page.
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'.
There are tons of references for this error message on the Web, but I can't figure it out. The problem is that the application works fine when I run it locally or when deployed to other servers. There is just one server where I get this error during a post back from an Update panel (it is supposed to populate and open a popup panel). There is no Response.Write() anywhere in the code and the other either. I think. The next thing I will try is install the remote debugger. In the meantime, can someone tell me how to check if server trace is enabled (IIS 6)?
We have the timeout value set to 120 in our <form> tag within the web.config. We do not have a session timeout set.. and we have various connection strings.
We are having a problem where a session variable will disappear (become NULL) .. but, the form evidently remains 'open'.. or no re-login is required..... so, my question(s):
1. what is the relationship between form timeout and session timeout
I have deployed my application to the remote server. But some error occures during that runs on the server. So i need to trace the server side code. I don't have Vs .net in my server but i have that in my client machine. Is there any way to trace the code from the client?
public abstract class AStateManagement : WebControl, IVFSStateManagement { protected PersistScope _StateManagement = PersistScope.ViewState; protected System.Web.UI.StateBag _ViewState = null; public virtual PersistScope StateManagement
[Code]....
I have create a custom textbox which will validated the data depending upon the business logic defined at run time. But currently i am not able to catch the update the value inside a textbox (entered by the user). I have implemented LoadPostData but i am unable to get the updated value.
I'm working with ASP.Net web services and am having a problem with a long-running process that takes about 5 minutes to complete, and it's timing out. To fix this, I was able to set the executionTimeout on the server's web.config to 10 minutes, and then set the .Timeout property on the Web Service object to approximately 9 minutes. Now, I'm worried that this may possibly cause some other web service calls to sit there for 10 minutes before they time out rather than the previous 90-100 seconds. I know the default on the client side is 100 seconds, but wasn't sure if updating the server's timeout setting would affect this.
Bottom line is - Is it safe to update the server's timeout setting to a long amount like 10 minutes, and rely on the default timeout on the client, or could this end up causing some problems?
We have an UpdatePanel that is showing a gridview with loads of data in it. We have loads of well written sprocs that don't take very long, BUT we have a few horrible ones that take ages.
We do intend to rewrite them but in the interim we have put the ADO.NET commandtimeout up to 180s. The scriptManager.AsyncPostBackTimeout is set to 240s. We want to handle this on the serverside. One of the reports still fails (it's got a couple of nested cursors in it - someone who hasn't had SQL lesson 101 from me!).
Half the time, the nice error timeout message is shown using server side handling of the command timeout. The problem is that the other half of the time the commandtimeout doesn't seem to fire.
I am having a problem with my ASP.Net Web application. The application is developed using vb.net and is linked to a SQL Server database. Let me explain how the application works and the problem I am experiencing. The system is an online web app which allows registered users to create a CV online. One of the pages within the app gives users the chance to add a cover note to their CV. The page that allows them to do this consists of only a textarea control and a button control. The textarea allows users to input up to 4,000 characters.
Once the user clicks the 'Save' button to save their cover note info, the following code then executes.This code checks to see if the CV already has cover note info, if it does, then the application runs an update statement, otherwise, it runs an insert statement.The table within the database which records the cover note information is called tbl_covernote and has three columns, covernote_id (int and autoincrement), cv_id(int), covernote_text (nvarchar(max)).
The error which occurs sometimes is as follows:
Dim dr As SqlDataReader Dim param(0) As SqlParameter Finally [code]...
I have an ASP.Net application that makes an AJAX request to retrieve at report. The report can run for a long time so I set the asyncpostbacktimeout in <asp:ScriptManager /> to 600. However, when I try to run the report, if it runs for longer than 90 seconds it fails to come back. I can see in the IIS logs that the POST request succeeded with a 200 status and I can see the time taken is much less than 600.
The web page dutifully waits for the entire 600 seconds before returning with a timeout error:
Error:
Sys.WebForms.PageRequestManagerTimeoutException:
The server request timed out.
Is there any setting I should be checking in IIS? Connection timeout is 900 seconds.
I need to know Is any tool available for Asp.net ?
My running website is sometimes getting too slow, So that I want to know where it happen. Also My Higher person asking Profiler report. Can anyone tell me how it looks?
i have done one website and i upload to all file in server..After two day i got error from website starting page Timout error.. too many connections are there so polling timeout..
We installed a web site on a developer's system (me, actually) which web site has been installed on six or seven Server 2003 systems. As the subject says, my system is XP, running IIS 5.1. The problem is that the Session object seems to be missing. Certainly,the stuff we store in there, one perfectly normal string, can't be found by any of the pieces of the website that want it. (It get's stored in the login script. It's the name the user logged in with.)We've tried both SQLServer and StateServer with the same results. When using SQL, the SQL Profiler shows activity against the SQLState database (TempSessions table). So something is being stored, but nobody can find it. (And I can't see from the SQL Profiler just what's being stored. The SessionItemShort field is being updated, but I can't tell with what.)
I have a page of each every click has ajax call to my server (hence, the ASP extends the session)
I have ASP.NET session set to Xmin. I want when X+1 min expires, I have expiration page. what I did was to set the JS timer to validate every x+1min to see if the session expired (the problem is that the JS and the ASP session timeouts are not synced)
I have an issue to where my users are logged into my system but thier session is null so when they try to do something in the system after 20 minutes, i get null reference expceptions because my session is gon What is the best practice for handleing the session, should i kick the users out before thier session ends and when they log back in thier session will return or atleast a new one will be created right? How should I handle this?
