Health Monitoring And IIS

Feb 5, 2007

Hi,

I have implemented health monitoring for my web-site, using the SQL provider.

Health monitoring works fine when the website is run from VS2005, using the built in web server, all the expected events are inserted into the aspnet database.  However when I deploy the site onto IIS, no events are ever inserted into the database. 

I would appreciate some help figuring out why this is happening!  The code that implements the health monitoring in my web.config file is:1 <healthMonitoring
2 enabled="true"
3 heartbeatInterval="0">
4 <bufferModes>
5
6 <remove name="Analysis"/>
7
8 <add name="Analysis"
9 maxBufferSize="10"
10 maxFlushSize="2"
11 urgentFlushThreshold="2"
12 regularFlushInterval="00:00:02"
13 urgentFlushInterval="00:00:01"
14 maxBufferThreads="1"/>
15
16 </bufferModes>
17
18 <providers>
19
20 <remove name ="SqlWebEventProvider"/>
21
22 <add name="SqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider,
23 System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"
24
25 connectionStringName="SQL_ASPNET"
26 maxEventDetailsLength="1073741823"
27 buffer="true"
28 bufferMode="Analysis"
29
30 />
31
32 </providers>
33
34 <eventMappings>
35
36 <remove name ="All Events"/>
37 <add name="All Events"
38 type="System.Web.Management.WebBaseEvent, System.Web,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"/>
39
40 </eventMappings>
41
42 <profiles>
43
44 <remove name="Default"/>
45 <add name="Default"
46 minInstances="1"
47 maxLimit="Infinite"
48 minInterval="00:10:00"
49 />
50 </profiles>
51
52 <rules>
53
54 <add name="All Events"
55 eventName="All Events"
56 provider="SqlWebEventProvider"
57 profile="Default"
58 minInterval="00:00:01"
59 minInstances="1" />
60
61 </rules>
62
63 </healthMonitoring>
64


 Thank you in adance!

 Jon

View 2 Replies


ADVERTISEMENT

Trusted Connection - Health Monitoring - Please :-)

Apr 10, 2006

Help Please!!! I am killing myself already...... the code is like this;
Read the code, and the error.... this is bull, because every page in the site, including base page, and opther classes in the same assembly as this class use the exact same connection string call and open. And it always works!!!! However, when going thorgyugh health monitoring, i get the error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
 
public class GBMSQLEventProvider : SqlWebEventProvider
{
private GBMErrorLog elog;
private System.Data.SqlClient.SqlConnection db = null;

public override void Initialize(string name, NameValueCollection config)
{
elog = new GBMErrorLog();
elog.Write("GBMSQLEventProvider Process Initialize");
db = (SqlConnection)GBMDB.Open("HealthMonitoring");  <------ THIS LINE CAUSES ERROR
base.Initialize(name, config);
}
 
ERROR:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error:



Line 30: elog = new GBMErrorLog();
Line 31: elog.Write("GBMSQLEventProvider Process Initialize");
Line 32: db = (SqlConnection)GBMDB.Open("HealthMonitoring");
Line 33:
Line 34: base.Initialize(name, config);Source File: C:GCMProjectsGBMFrameworkGBM.Web.UIEventsBufferedProvider.cs    Line: 32 Stack Trace:
Regards, and thank you in advance,
Jonathan

View 10 Replies View Related

SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring

Sep 15, 2014

We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.

View 2 Replies View Related

Health Checks On SQL

Jul 15, 2004

I'm starting to collect and develop some scripts that will tell me the health and welfare of my MSSQL 2k server. I have a few for blocks, db size, who is on and what they are currently running.

I was wondering if you guys could share some of the scripts you guys use to watch the health of your servers.

Thanks,
DMW

View 1 Replies View Related

Health Checks

Jul 15, 2004

I'm starting to collect and develop some scripts that will tell me the health and welfare of my MSSQL 2k server. I have a few for blocks, db size, who is on and what they are currently running. I was wondering if you guys could share some of the scripts you guys use to watch the health of your servers.

Thanks,
DMW

View 1 Replies View Related

Database Health

Feb 28, 2006

What all are the command , or what for should one look out to confirm if nothing is wrong with the DB & its the application that is creating a prob..
I mean command for checking the health of the DB.


Thanks,

View 4 Replies View Related

Reporting On Health Of Db??

Jan 17, 2007

Hey all
I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb.
My boss wants me to reporting to him the health of the DB each week. So here are a few questions.
1. What really defines the "health" of a DB? What elements should I be reporting to him?
2. Is there any utilities out there that would be helpful or can SQL provide enough info?
3. I am using 2005 standard, so I have the shipped reports in summary page. But is this enough? and can I customize them?
Sorry I am having a hard time even asking the questions cause I am not really sure what to ask. Any help or pointing down t he correct path
would be greatly appreciated.
Thanks,
jason

View 1 Replies View Related

SQL Server Health And History

Oct 5, 2004

Anyone had time to play with this yet? Wanna know if it was worth playing around with.

View 2 Replies View Related

How To See Health Check In Sql Server

Apr 9, 2008

Hi,

can anybody help me that how can we see sql server Health check with t-sql.Because i am trying to make script for this
Basically i need these info..
1.Current Date
2.Current time
3.Session,id
4.Session name
5.all locks
6.cpu utilization
7.how much disk space is used inside the database
8.how much space is free inside the database
9.Date read
10 Date write
11.how can we see process information with t-sql or with stored procedure

and i have solved 6 problems from this list i made queries for this .
will u plz help me
thaxxx

jagpal singh

View 2 Replies View Related

Database Server Health Check

May 9, 2007

I want to run Profiler Traces, Perfmon Checks and whatever else to see what hits the server the hardest in order to work out where I can make performance improvements. We don't have any massive problems other than more timeouts than I would expect from web users no-and-then when they do pretty simple free-text searches. I just want to see if I can lighten the load on the server in general.

Where does a DBA get the most ROI? I don't want to drift into the realm of diminishing returns where I am making changes that have no noticeable impact.

What should I start measuring first and how do you measure it? (E.g. if I should monitor disk writes in Profiler, how many writes are too high for a statement? 100? If so, is one 100-write statement per hour OK but one 100-write statement per second is not OK?)

If there is already an article for this, my apologies. I'd be grateful if you can point me to it.
Is http://www.sql-server-performance.com/ a sufficient one-stop-shop for this question? If so, have you found some articles there to be more useful than others?

View 5 Replies View Related

Microsoft Cluster Server Health Check.

Jun 29, 2005

Hello,

View 2 Replies View Related

Microsoft SQL Server Health And History Tool Version 2

Sep 15, 2004

Recently I've installed Microsoft SQL Server Health and History Tool Version 2

and The SQLH2 Reports are a set of reports that provide different views on the data

that the tool collects. But unfortunately I can be able to see Data on Performone counters

Report. I can not find optional component SQLH2 Performance Collector is a stand-

alone service of Microsoft Windows that collects and stores performance counter data from

selected servers.

The Deployment guide tells :

Performance Collector is optional, and is available for download from the Microsoft Download Center (search for SQL Server with keyword SQLH2): http://www.microsoft.com/downloads/search.aspx


But it does not give result

Where can I find the missing component ?

Thanks

Oleg


:(

View 1 Replies View Related

SQL Server 2000: Replication Latency Health Check

May 25, 2004

Hi Everybody,
Can anybody tell me how to get the number of commands delivered per minute in case of Merge Replication with Publisher and subscribers.
This way, we can be sure that even if there is a latency (due to high volume transaction processing), replication is in good shape and things will catch up soon.
Also if there are any other similar measures which can be monitored to make sure that replication is going on fine, it would be great

Please let me know If anyone has got information on same.

View 1 Replies View Related

SQL 2012 :: Approximate Hours Per Month To Monitor And Maintain Health Of Databases?

Jul 8, 2014

Based on the description below on average how many hours a month would it take to monitor and maintain the MSSQL Server databases?

Description of IT infrastructure.All Windows Servers and MSSQL Servers are up to date on patches and best practices.

Corporate site with 3 remote sites.

All remote sites have one DC and one MSSQL Server.

The corporate site has one MSSQL Server.

Replication is performed between the remote MSSQL databases and the corporate office MSSQL database.

There is no in-house DBA. All DBA services will have to be outsourced. I am trying to determine what is reasonable in budgeting for time involved for this service.

There is one project written in MS Access using Visual Basic for Applications (VBA) with the backend residing on these database.

The question is on average approximately how many hours a month would it take to monitor and maintain the health of the MSSQL Servers database by a MSSQL DBA. The DBA will not have to create any user reporting, queries, etc. Just maintain the existing MSSQL Servers database.

View 9 Replies View Related

CPU Monitoring

Jul 31, 2002

Hello,

Is there a way I could get the total cpu usuage of the box other than Task Manager and Profiler

Thanks
Rea

View 1 Replies View Related

CPU Monitoring

Aug 16, 2000

I understand the rule of thumb that the CPU should not be over 90%. If you take the four counters (%processor time,%privileged time, %user time, %interrupt time, and interrupt seconds), what combination gives you your CPU
time ?

View 2 Replies View Related

SQL Monitoring

Mar 26, 2007

Hello,

I am looking for a reliable and easy manner to poll a domain for any box running the sql server service. Our current monitoring tool doesn't do this.

Many thanks!

View 3 Replies View Related

SQL Monitoring

Jul 23, 2005

I have been asked to monitor SQL to tell me when we are performingbetter than others. Can anyone tell me what kinds of scheduled jobs orscripts they utilize?

View 1 Replies View Related

Monitoring

Jul 20, 2005

Hi ,Is there a way/tool in Sql Server 2000 SP3 tomonitor all activities going on in the Database ?For example, I first create an empty database.Then I have an ERWIN generated DDL to createall views and tables. After that, I have INSERTscripts that populate all the base tables. What Iwant to monitor is success or failure for eachscript.Thanks,N.

View 2 Replies View Related

Filegroup Monitoring

Jun 21, 2002

Can anyone show me in SQL7 how to obtain Available Space on a particular filegroup in a database (not the database or datafile).
I am trying to include this in a script to monitor my database which uses Filegroups and I have every other info that I need (from the sysfiles table) except the available space. Thanks in advance!

View 1 Replies View Related

Monitoring Server

Jul 10, 2002

Hello,

I do all my monitoring locally for disk space, locks, blocking, I've 10 production servers, We need to centralised the monitoring server so from one server all the monitors can be done. Does anyone has any ideas how memory, cpus consumption, disk space, all alerts, locks, blocking, log space and job completition monitoring can be handled.

Any idea or guidance is appreciated

Thanks
Roma

View 2 Replies View Related

Login Monitoring

Sep 4, 2001

In Sql 7 What is the easiest way to monitor the number of connections? I have been asked to create a report that monitors the number of logins every hour.

Please Advise, and thanks in Advance.

View 2 Replies View Related

Performance Monitoring

Apr 5, 2000

Hi,

I am new to sql server and sould like to know how I can monitor the server performance on sql servers 6.5 and 7. In sybase we can run sp_sysmon. Is there anything similar to this for sql server.

Thanks.

View 1 Replies View Related

Performance Monitoring

Apr 17, 2000

Hi

I am learning SQL SERVER ..Can anyone tell me how do I tune a given stored procedure in 6.5 and 7.0.?

In performance tunning which counters are really necessary to watch and the remedies to be taken?

Thanks
Reddy

View 3 Replies View Related

SQL Server Monitoring

Jul 8, 1999

Folks!
Is it possible to monitor several SQL servers in one window and notify operator about error messages.
May be some new software can make it possible?
Thank you.

View 2 Replies View Related

Database Monitoring

Jan 19, 2005

Can anybody help me with the following on my MS SQL Server 2000 database.

1. All tables should have a lastModificationDate column. Any changes and inserts should have the system time updated with a trigger or so. We shouldn’t be inserting the value using SQL statements into this column.

2. There shouldn’t be any deletes on the table. Any deleted records should be marked as inactive or deleted, so it won’t come in queries, but should be physically present in the tables.

3. A modification log table, which will carry the table name, the column identifier, user modified, old value and the timestamp.

Thanks
Kishore

View 1 Replies View Related

Monitoring Usage

May 10, 2006

I would just like to know what everyone uses to monitor SQL usage? We have a SQL 2000 server that already has several applications sharing it and everyone wants to keep forcing more onto it.

I want to be able to judge when this server has reached it's capacity or how much more it can allow. Can SQL profiler alone do this for me?

Thanks.

View 1 Replies View Related

Performance Monitoring

Mar 8, 1999

Does anyone know of a way to determine which SPs or which tables are being accessed the most heavily or often from an application? I have inherited a site that is heavily used, but poorly tuned. However we have distributed C/S apps that hit the server and do not contain debug code. In addition, the SPs are encrypted and I do not want to replace them in the short term with new SPs that log hits.

I realize I can use triggers, but is there any other method?

View 1 Replies View Related

Monitoring Tempdb

Apr 12, 1999

Is there any way to watch the activity of the tempdb in 6.5 similar to using 7.0's profiler. I would like to see how often it is utilized and how large it grows during utilization. Any help would be appreciated.

Thanks,
David

View 1 Replies View Related

Monitoring Tools

Dec 22, 2004

Hi all,

I'm looking into the possibility of buying (as I doubt there's any good free options) a SQL Server Monitoring tool.

Has anyone got any particular recommendations - good or bad? I know a little about Spotlight, but not much else.

Thanks in advance.

---------------
zinedunc

View 2 Replies View Related

Database Monitoring

Jan 19, 2005

Can anybody help me with the following on my MS SQL Server 2000 database.

1. All tables should have a lastModificationDate column. Any changes and inserts should have the system time updated with a trigger or so. We shouldn’t be inserting the value using SQL statements into this column.

2. There shouldn’t be any deletes on the table. Any deleted records should be marked as inactive or deleted, so it won’t come in queries, but should be physically present in the tables.

3. A modification log table, which will carry the table name, the column identifier, user modified, old value and the timestamp.

Thanks
Kishore

View 1 Replies View Related

DB Monitoring Tool

Jan 28, 2005

Hi all,

I am new to the db world so please let me know if I don't make any since.

I was wondering if there is an open source SQL database monitoring tool out there that I can run on my desktop that would give me a log of what is going on on the database (or the server).

Thanks.

View 2 Replies View Related

Monitoring The Db Size

Nov 3, 2005

Hi All,

I'm wonderring if someone has the script which can run on each server to get all dbs size , free space on this server ? Curently I am using the enterprise manager to check the db space usage manually, but this is very frustrated due to a server has many dbs located on it

Thanks,

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved