DataSource Controls :: SQL Server Monitoring Through Web App?
Feb 24, 2010
I got a task to develop a web application (ASP.NET) for monitoring several MSSQL servers within our company.
Monitoring services would be MSSQLServer and SQLServerAgent - monitoring connection, power on, job failures,job activities....Any ideas how this could be done?My thought was maybe after connecting to a given server to call some stored procedures and get some data out of them and than display those in my webapp....how can I find out a type of a connection failure?....how can this be done in a real time?(AJAX+timer?)
I've got my e-mail health monitoring working fine (removed here) but when I try to get it into SQL Server it fails. When I run the stored procedure (aspnet_WebEvent_LogEvent) manualy it works OK. But nothing happens when I create an error (but I go get my health monitoring e-mail). What can I have missed?
i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:
string path = Server.MapPath("~/uploadaccess/Production.mdb"); string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";"; and also OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";"); and tried this OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));
and this is the error i am getting:
Operator '&' cannot be applied to operands of type 'string' and 'string'
I looked at Google's, but my boss shot it down because it involves adding a script to every page you want to track. I keep searching the web, but the stuff I am finding seems to be crap or not work all together. This is mainly for internal sites, not external. Seems liek a lot of the stuff I am finding want to give me remote statistics to a publically available site.
My boss has it in his head that we need to be monitoring our websites more to see what king of traffic we are getting for but internal and external sites.
I was going to use ELMAH for our ultimate automatic error logging but recently realized that ASP.NET Health Monitoring does a same work (perhaps). Now I want to know (please) if they are alternatives of each other just like log4net and entlib?
I have either an ASP.NET displaying my results, or a Silverlight client. And I'd like to show the current status of my server, or embedded device. (pretend the device reads temperature and humidity stats)
How should I send the status information from my device to the front end? Should I poll the device and save the results to SQL, Azure Table, or the like? (Azure is a technology that fits with this project for other reasons. That's why I mention it) Or should I create a WCF service that polls the device directly and returns the current status.
I'm experiencing some really odd timeout issues when running a ASP.NET 2.0 project on Cassini on localhost, and I don't have enough data to get a clue of what's going on.
Is there a way to monitor localhost traffic to Cassini, either using some specific development tool or a general-purpose monitoring app such as fiddler?
Just to pre-empt some answers I'm already aware of:
Normally I can use the well-known dot-hack for using fiddler to monitor localhost traffic, but with Cassini I get the following error message in the browser:
[Fiddler] Connection to localhost. failed. Exception Text: No connection could be made because the target machine actively refused it ::1:3213
Fiddler also listens to localhost on http://ipv4.fiddler:port, and I can intercept the traffic. But when I do this the timeout issues don't occur!
Edit: Oops. This question had already been asked... Twice.. Didn't come up on search or . The solution found in the second thread is to use the dot-hack with ip-address (http://127.0.0.1.:port/ instead of "localhost". This question may be closed.
I am planning to build a custom web application in ASP.NET 4.0 using WF 4.0, the user wants ability to modify workflows himself, for this we will be using a WPF client which the user can use and we will do workflow re-hosting, lots of blogs and guidance is available for this. But I am not sure how to the meet one requirement where the user wants to see/track a visual representation (diagram/image) of the workflow, depicting what stages are over, what is the current stage etc. This needs to be done on a web page.Possibly the same workflow with icons depicting status. This is something similar to the visual available for Visio workflows in SharePoint 2010. Even AgilePoint workflows provide such a view.
got a new bigger, better, faster pc at work. Installed VS 2008 and went back to normal developing in VS 2008 on my pc, with the files on our dev server, which is on the network. But, whenever I set a breakpoint, and enter Debug mode, I get this error: An error occurred loading a configuration file: Failed to start monitoring changes to 'ServerABC' because the network BIOS command limit has been reached. For more information on this error, please refer to Microsoft knowledge base article 810886. Hosting on a UNC share is not supported for the Windows XP Platform.
I have to create a windows service which Monitors a specified folder for new files and does someprocessing on it and moves it to other location. I started with using FileSystem Watcher. But my boss doesn't like FileSystemWatcher and wants me to use polling on Timer or any other mechanism other than File System Watcher. I am confused right now. It would be great if anyone could point me to some examples for how to monitor Folders without using File System Watcher in .net environment.
i'm te new begginer in this forum and in mobile device i want to ask to you all about monitoring hardware using cell phone especially cpu usage and memory usage. can you all help me, give me some example code, please.i hope you all can answer my question soon, cause i need to finish my last project for complete my study.
In a VS 2005 C# web app, I've implemented change monitoring, so that if the user clicks the Cancel button after having changed the value in one or more controls, they are presented with a dialog box in which to confirm that they really want to discard the unsaved changes. I've set up a utility class, which includes the code shown below. Each of my edit pages inherits from the utility class, and in each of their Page_Load() methods I include a call like this:
EstablishCancelConfirmation(btnCancel, "Data has changed - OK to cancel and discard changes?");
I have come across this question several times, you need to do some performance testing (request process times, load times, etc) or track unhanded exceptions. The answers usually come down to writing a HTTP Module, hook into specific events and log them somewhere, or use the built in health monitoring?
Why would we use one over the other? What are the pros and cons?
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
We have a cient we are stting up that has 2 separate physical servers, one that is the web server the other the database server. Using impersonation we have been able to get the website to connect and retrieve data from the sql server so that part is not an issue. The problem is I have a windows service application that must be installed on the web server (as it process files downloaded to an ftp site) and it must be able to connect and write to the sql server as well.We tried adding a system.web block with the impersonation stuff to the app.config file which of course did not work. Can anyone tell me what/how we need to configure this properly?
Not sure why it works if i connect to SQL 2005 on another server, but now that i have SQL Express on the same server as the pages, im getting the following error: I have attached my connection string within my web.config and also how its being called within the code behind. Now this page was written by another programmer some time back.. so not sure if the method he used to do this is the best or only way. But i have connected to other SQL database with other applications with alot less code.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error: Line 131: Line 132: //connect to this sql server Line 133: c.Open(); -----> this is the line it complains about.[Code]....
I want to organize twenty-four-hour local network monitoring. Could you tell me about such program? The program has to ping hosts and save results in files on hard drive for viewing.
