Monitoring SQL Statements Application-side By Attaching To W3wp/WebDev.WebServer.exe?
Dec 1, 2010
Oracle has simple, useful and free tools for attaching to a process and monitoring its SQL statements but I can't anything similar for SQL Server. This is incredibly useful across a number of scenarios, particularly when dealing with third-party assemblies (1). ANTS 6 seems to support something like this (2), though it doesn't allow you to view the stack-trace that lead to the query as dynaTrace does. I don't think dotTrace tracks parameter values, either.
Surely there's a widely available option for profiling SQL application-side?
(1) -
[URL]
(2) -
[URL]
View 1 Replies
Similar Messages:
Jul 1, 2010
Currently this is the location of my WebDev.WebServer.exe -> C:Program Files (x86)Common FilesMicrosoft SharedDevServer9.0WebDev.WebServer.exe
I want to change it to -> C:Program Files x86Common FilesMicrosoft SharedDevServer9.0WebDev.WebServer.exe
Notice that the new location has no parentheses (because this might be the cause of an oracle connection problem I'm having (using Oracle.DataAccess))
I'm guessing simply moving it to the new destination will cause some problems, so what will I need to do to the Visual Studio 2008 configuration?
View 2 Replies
Jul 25, 2010
I wantto make a slower transmitting/transferring data speed for debugging issues.(no threading sleep is not my answer) searching a way to limit webdev.webserver speed (bandwidth) ?
for example maybe checking on "custom web server=webdev.webserver /BandwidthLimit=128bs"
View 1 Replies
Jul 13, 2010
I have running my application. some error is displayed at every time. what is the meaning of this error
"WebDev.WebServer.exe has encountered a problem and needs to close.we are sorry for the inconvience. If you were in the middle of something , the information you were working on might be lost. "
View 1 Replies
Jul 29, 2010
I am trying to allow for multiple selection check boxes that are created dynamically.
The Following code is written for each row in the dataTable (I print it as HTML code)
<input type='checkbox' name='multiCheck' id='chk{1}' value='{1}' runat='server'/>
however, on the server side (after postback) I can't read them from the Request Object. How do I "mark" them so I can read them at the postback?
protected void DeleteSelection_Click(object sender, ImageClickEventArgs e)
{
int multiIdsToDelete = Request.Form["multiCheck"]; <-- In the Future will be added to an array so I can do the delete for each row selected.
}
View 6 Replies
Mar 9, 2011
Which process running on an IIS web server is responsible for the creation of w3wp.exe worker processes for each asp.net application?
View 2 Replies
Dec 20, 2010
an unhandled win32 exception occurred in w3wp.exe error occures when we run .Net application from IIS. My configuration is Windows server 2008, IIS7, .Net 2.0, and Oracle 10g.
View 2 Replies
Oct 14, 2010
I have an app configured to use anonymous authentication, the application pool is set to network service. When I run filemonitor I can see that thw w3wp.exe is picking out the webpages and stuff from my hard drive and returning images etc. However one of the pages saves a file to a folder using c# save() method. Instead of the w3wp.exe actually writing the file to disk explorer.exe seems to be accessing the folder. What the hell is going on? I though the w3wp.exe did everything asp.net related why on earth is explorer.exe being introduced into the fold here?
View 1 Replies
Mar 19, 2011
I want to attach the sql server database to my asp.net web application. How can i do it ?
View 1 Replies
Jul 28, 2010
What I am trying to do is install an open source application to my existing asp.net website. Within my solution in VS2008, I have two "Web Sites", one for my web site and one for the application (forums).I have my web site published to the main domain, and the forums web site published to a subdomain. They both work great.The problem I am having is that I cannot get them to communicate to each other, for example they can't access each others resources. They each have a separate membership provider, but I am attempting to combine them so that if the user logs into one, they are logged into the other. The reason that I have these as two separate web sites within one project is so that the forums can be hosted at the subdomain and the site would just be the main domain.My question is, would it even be possible to accomplish what I am trying to do using separate domains, and if so what would be the best approach?
View 3 Replies
Feb 8, 2011
I have a CLR 4 WCF service hosted in IIS 7.5 (Windows Server 2008 R2), using the WebHttp binding (with [WebGet]). The service calls into an unmanaged component implemented in C++ (Visual Studio 2010). I deliberately added an access violation inside the unmanaged component (by calling delete on a pointer repeatedly, calling methods through a deleted pointer, etc.) to test dump file generation settings. The access violation crashes the w3wp.exe process, which is not surprising considering "Corrupted State Exceptions" in CLR 4. However, when the process restarts (due to warmup and always-on settings in IIS), the same request seems to be replayed to the service so that it crashes the w3wp.exe process again. After a few times (governed by the "max failures" application pool setting) the application pool is stopped.
I'm using the browser as the test client, and while the restart sequence is underway the request is still in flight. When the application pool is stopped, the request returns with 503 Service Unavailable. I can work around the problem by placing try...catch block around the code and using the [HandleProcessCorruptedStateExceptions] attribute. When I do that, the w3wp.exe process does not crash. However, this is not the desired behavior -- I want the process to crash (an access violation or a memory corruption is bad enough) but I want it to restart into a clean state and not have the request replayed. I was not able to reproduce the problem using the BasicHttp binding.
View 1 Replies
Feb 23, 2011
I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?
View 6 Replies
Jan 24, 2011
I'm trying to set my WebService to a Application variable, but I can't use after all...
Application["sorts"] = new Sorts.Sorts();
Ok, so when I type Application["sorts"] and put a periond in front, instead get the list of the WebService methods I just get the Equals, GetHashCode,
GetType and Tostring.Probably it's belongs to the Application thing itself.
View 1 Replies
Apr 9, 2010
I have an Asp.net web application which have one WCF hosted inside a .svc file
<%@ ServiceHost Language="C#" Debug="true" Service="MYNameSapce.BatchService" %>
this service is access by some desktop application which have referenced it.
In one of my WCf service method i have to access the path which i were able to get via
string filePathTemp = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + @"UploadFiles" + request.FileName;
Now in one of the method i wanted to get the computer Name of the server.
View 2 Replies
Sep 13, 2010
I have one webserver alone in the network and all the users authenticate in another server. I'm trying to implement windows authentication in a application in the webserver, but every time that the page loads a login window appears exactly that the windows client was authenticated in the order server. Is It necessary both server stay in the same domain? Is there another way? Finally, I need to get the user id in the windows client, but webserver and domain server don't communicated between itself.
View 1 Replies
Apr 16, 2010
I'm quite new to ASP and I can't seem to figure out how to get the application/website to work properly on my webserver. The first thing I had done was to build the solution, shortly followed by 'build website' and at last, to 'publish website'. It saved the files to C: -> Documents -> MS VS -> Projects -> My website.
There, the following files are found:
Account [folder]; App_Data [folder]; Scripts [folder]; Styles [folder]; bin [folder]; Web.config; Site.master; Default.aspx; About.aspx and PrecompiledApp.config.
I then uploaded these via FTP to my webserver and accessed the appropriate URL. Seems nothing showed up in root beside "Index of/". When I tried to access /Default.aspx, nothing but text appeared (which would be the code displayed in Default.aspx).
I've also read some tutorials regarding this matter where they instructed me to upload directly from Visual Studio to the FTP server, but I'm kind of afraid that it'll delete everything in said folder, as I don't know what the structure of said direct upload should be like.
View 2 Replies
Jun 22, 2010
How can I deploy custom web service to iis side by side with asp.net application (in my case dotnetnuke site)?I deploy to server web service [URL] Service work great.When I deploy DNN 5.x.x web site work great, but my web service stop working, I get following error:
----------------------
Server Error in '/ directory_name ' Application.
________________________________________
Could not load file or assembly 'DotNetNuke.HttpModules' or one of its dependencies. The system cannot find the file specified.
----------------------
ASP.NET app and WS is in same root directory.I remove web.config file from my service folder, and merge relevant entries into the web.config file in my ASP.NET app (DotNetNuke site).I get the same error.I get same error in my development enviroment - win7 and production enviroment w2k8. you advise me please what I should change in server IIS or ASP.NET app web.config?
View 1 Replies
Mar 15, 2011
On one server, everything works. I am attempting to call a C++ assembly from C#/ASP.NET application.
When I deploy the web application in another server, it fails with the error message:
"The application has failed to start because its side-by-side configuration is incorrect" I have copied the dll into the correct folder which has permissions for the user and the application pool identity. The path has been added in the PATH variable. The DLL is fine and is not dependent on any other DLL.
View 1 Replies
Oct 13, 2010
i wrote code, and it worked fine on webdev server in vs2010.i hosted it on remote iis, because, my windows 7 home basic doesnt have iis, and almost all code fails,so i had to rewrite it with using helpers for links, ResolveUrl and many other functions.So here is the question, how can i host application, while debugging, not on webdev or local iis, but on remote iis, automatically?
View 1 Replies
Mar 7, 2011
I´m using a template that comes with visual web developer 2010. It uses a css style sheet.
After several weeks of frustration I figured out that changes to the stylesheet doesn´t take effect until I reboot the computer. Not the webdeveloper, but the computer(!). This cannot possibly be right, can it? How do I force the webdev to apply changes to the css?
View 7 Replies
Jul 28, 2010
Using VS2010 Pro, I started up an web site and got the message "WebDev.WebServer20.exe has stopped working" - a very similar problem was reported at
[URL]
I checked C:WINDOWSassembly and found that System 2.0.0.0 was missing (again!), reinstalled it but still got
""
System.ArgumentOutOfRangeException was unhandled
View 4 Replies
Dec 17, 2010
I'm debugging an ASP.NET MVC 2 application running on .NET 4.0 (Windows 7), currently inside of Cassini, the Visual Studio Debugging Web Server.All was running well, when I suddenly was having exceptions in my Application.EndRequest handler. After investigating into this issue, I found the reason was that Cassini was calling EndRequest on a different thread than BeginRequest (then, a ThreadStatic variable which was set in BeginRequest and used in the EndRequest handler was null, since on this thread, BeginRequest was never called).What could be the reason for Cassini to execute BeginRequest and EndRequest on different threads?I know the reason could be an 'Async' Page directive (see Do ASP.NET Requests always BeginRequest and EndRequest on the same thread? , but I have no 'Async' attribute in my Page directives).
View 1 Replies
Mar 10, 2010
I'm running IIS 7 on Server 2008, with a single AppPool for an application which is basically just a collection of ASP.NET WebMethods. Some of these methods process for hours before they return. What's weird,is that sometimes when I launch multiple simultaneous requests IIS spins up a single w3wp process (and seems to share it amongst the requests) and other times it spins up multiple w3wp processes.
View 1 Replies
Oct 26, 2010
I'm running a Windows 2008 server (a VPS with 1GB of RAM), with SQL Server Express and IIS 7 installed. On it I'm hosting a NopCommerce 1.7 website, with a database of around 26 000 products.
Right now I'm the only user of the website (it's in development) and I'm getting rather bad performance from it. To be more specific every time I make a request, the worker process goes to 90-100% CPU usage for a few seconds. Is it me or this is a lot for a 1 user NopCommerce website?
PS: the worker process uses between 100MB-400MB of memory (private working set), and SQL Server with this database, around 160MB.
View 2 Replies
Jan 8, 2011
I wrote a windows service of batch processor to request statistic information from a web service whose url is end with *.ashx. The windows service and web service are on the same PC. When the batch tasks started, CPU usage came from 1% to 99%, w3wp.exe took 70%, and sqlserver.exe took 29%. About five minutes later the batch process tasks completed, but CPU usage still kept the level 60%, w3wp.exe took 40%, and sqlserver.exe took 20%, and it's never down. Request codes in batch processor are:
[Code]....
How can I bring down the CPU usage? PS. OS version WIndows 2003 sp2; SQL 2008 sp2; iis 6; Four Cores AMD CPU; 4G Memory
View 1 Replies
