Monitoring Production Instances.

May 10, 2006

We will soon have 200 + production instances. In an effort to be more
pro active, I am looking for a way to monitor jobs, both failed and
long running, Disk space, and other such things like CPU load etc.
I would appreicate any suggestions you might have on accomplishing
this. For instance, is there anything in reporting services that might
help accomplish this ? Most of the instances are 2k, but we also have
some 2k5.
Best Regards
SGB

View 1 Replies


ADVERTISEMENT

SQL 2012 :: Monitoring Multiple Instances

Oct 22, 2015

I am using sql2012 with partitiondb custom installation over 6 dbs on 4 servers, ~200GB per db. I am looking for the perfect graphic tool (similar to Perfmon+Activity Monitor) where I can monitor a wide-scope SQL environment. I am interested in data / log / table / index growth, buffer cache hit ratio, average wait time, physical/logical reads/writes and such. I am interested in real-time / time-range metrics. I know I can issue immediate queries against dm_os_performance_counters / dm_os_buffer_descriptors / dm_exec_query_stats and get some of the relevant data, but is this the only way?Also, for your opinnion, what are the most crucial metrics to monitor when dealing with multiple dbs?

View 1 Replies View Related

Multiple Instances Ready For Production Prime-time?

Jul 20, 2005

Hello,Is the multiple instances capability of SQL2K mature enough for aProduction system?We're looking at upgrading our hardware but the proposed solutioncalls for consolidating two currently separate SQL Server's onto onemachine with two CPU's.Of the current two servers, one is for OLTP (~800Mb) and the other forreporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTPdb nightly and archive the purged data in the reporting server whereit stays for a couple of months before getting purged from there.Maybe I'm being overly cautious here but the OLTP system is especiallytime-sensitive. If anything causes it to slow down significantly welose $$$.Thanks,Martin V.

View 1 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

Generating User Instances In Sql Server Is Disabled. Use Sp_configure User Instances Enabled To Generate User Instances.

Sep 28, 2007

 When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance. 

View 4 Replies View Related

Named Instances And Default Instances Of SQL Server 2000

Jul 18, 2001

I had a server with SQL Server 7.0
I installed a named instance of SQL Server 2000 and then i passed all my DB
of the 7.0 instance to the 2000 instance.
Then i removed the 7.0 instance, that was the default instance.
So at the moment there is only the 2000 version, but it isn't the default
instance
Can the 2000 instance become the default instance? (So that clients can
connect to it simply through computer name, and not creating an alias)

thanks

Fede

View 1 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

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 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

Monitoring SQL Server

Nov 7, 2005

I believe we are reaching some limitations with SQL Server and I have been monitoring certain items in the Performance Monitor such as: pages/sec; Bytes received/sec; Bytes sent/sec; % disk read time; % disk write time; % processor time; Log growths; percent log used; and transactions/sec. I notice quite a few spikes in Bytes sent/sec and when the % disk read time spikes for more than a few seconds, users notice a delay.

My thoughts are that 1: We need more memory on our SQL Server box (we currently have 768 meg, need a faster SQL Server box and need to distribute the load of some databases to another SQL Server; and 2: We also have a bottleneck when users are connecting via Citrix to SQL Server via our Terminal2 server (which has been tracked down to simply a slow Terminal2 box with a slow nic card - This has been confirmed that our Terminal2 is definately taking a toll and will time-out when large queries are executed.)

We also have been monitoring each of the server boxes. Are there any other recommendations for SQL Server Performance monitor that anyone could see which would be good to monitor (there are several things which can be selected to monitor?)

We've also noticed that bound MSAccess forms seem to play a significant role in the long spikes for Bytes sent/sec. I'm assuming this might be normal for bound forms and the slow SQL Server box with limited memory. Unbound MSAccess forms do not seem to present any problem and show as quick spikes for the Performance monitor.

Another problem is that I also can't seem to tie back the Performance monitor spikes with specific transactions in the SQL Profiler. Is there any way to pinpoint a spike in the Performance monitor with a specific transaction other than trying to catch the spike and quickly switching to SQL Profiler?

We are planning on upgrading our SQL Server box and also adding in another SQL Server box to help distribute the load with certain databases. We are also getting a faster box for our Terminal2 (citrix) server as these slow-downs/time-outs do not happen internally or when we use Remote Desktop Connection to connect externally (only when we connect externally via Terminal2).

Any help would be greatly appreciated! Thank you in advance.

View 2 Replies View Related

Automatic Job Monitoring

Jul 16, 2006

I'm a SQL Server 7/2000 DBA and manages about 40 servers in different networks. Every morning I check through the Enterprise Manager if all Jobs (backup, maintenance, etc.) have run successfully. This check costs me 1 hour per day.

Because of a reorganization I've got some new college's and lost some college's. My new college's think this is to much work, so it should be automated. They only want the failed jobs to report an error on a website or something like that, and don't want to check 40 servers. I don't agree in this, because I'm affraid I'm going to miss some errors.

How do you do your checks every morning?

Thanks,

Marco

View 2 Replies View Related

Monitoring Tools

Mar 7, 2007

Hi,

We are evaluating proactive monitoring tools for our heterogeneous database environment, currently comprising of Sybase and MS SQL Server.

Our current options are Bradmark Surveillance, Quest Foglight/Spotlight, MOM (SQL Server only) & Embarcadero Performance Center.

Are there any recommended tools from your experience? Or any tools with with you have had bad experience?

Tia.

View 2 Replies View Related

Performance Monitoring

Jan 13, 2004

Hi,

I want to collect performance measures regarding the import of data
and the growth of resulting extract_tables.

I use - say - 15 tables from a erp-system (like JDE Edwards)
to build a -say - sales-warehouse and a MS-OLAP-cube.

For every incoming table I got a dts-package witch is
protocolled into msdb.sysdtspackagelog.
Every package got the name
[Build]_[Subsystem]_[Table_name]
e.g. JDEdwards_Sales_F0005
The destination table is namend e.g. extr_F0005

Now:
With a seperate DTS-package I transport the
records from msdb-db into my build-db
- say - JDEdwardsExtract.
Name: extr_performance_monitor
(eventually filter on buildname, because there are several builds in
my system)

So this result is quit good and easy to handle for
seeing elapsed time per day.

But the dtslog won't tell me, how many records the dtspackage
had to copy.(and there is one at least with no records (Cubeupdate))

Now the count(*) comes in.

In the dts-package
sys...log ---- to --- extr_performance_monitor
I added the columns
extr_table_name,
extr_table_rowcount,
extr_table_timestamp.

With
select name, 'extr_' + replace(name, '[Build]_[Subsystem]','') as
extr_table_name from extr_performance_monitor
I cut the original dts packagename down to the extr_.. name.

But I don't have a clue how to solve the count(*)

Example:
dts_package_name,.... , extr_table_name,extr_table_rowcount, extr_table_timestamp

[Build]_[SS]_[F0005], ..., extr_F0005, 0, sysdate.

I think about a package wich is running after the last
data_import (and cube_refresh) is done.
(but the same day)

So the result could be:

Table_name (as dimension category)
Time to perform
Number of records in import table
Records per second.

The next step could be to look for required space.

The result should be a grafik - say - over 12 month
were you can easily see the amount of data performend
time consumend, (table space used),
and - very important -
you could extrapolate your hardware requirements.

Looking forward for any hints.

Thanks in advance.

Michael

View 1 Replies View Related

Performance Monitoring?

Apr 14, 2004

My SQL Server 2000 system is pegged. Disk activity is maxed out and system is very unresponsive. Several people have database tasks running through this system and I'm pretty sure there is a single application that is the culprit and I'd like to identify which one.

Does anyone have any practical tips on using "Process Info" in Enterprise Manager? What units are CPU and Physical I/O displayed in? Why does the column sort on these fields not work as expected?

Do I just pick the process with the largest Physical I/O and assume that's the problem?

View 1 Replies View Related

Monitoring SQL Server

Dec 5, 2006

Iam new to Sql server 2000 administration , would need inputs on counters to monitor so that I can do regular health check up of the system.

Environment:

Sql server 2000 SP3
windows 2003 sp1
2GB RAM
2GHZ processor
Total size of 23 databases = 7.38GB

Counters currently montioring using the task manager on sqlserv.exe :

1. Mem Usage I assuume amount of RAM is consuming
2. VM size is virtual memory in play
3. Page Pool - Not sure what this is ? assuming paging mechnaism in windows
4. NP pool - Not sure on this
5. I/O reads - reads like select to db
6. I/0 writes - insert and update to DB
7. Page File usage - Not sure on this too, please explain

Any other counters or freeware tools to use please suggest and also please explain the above counters 3,4,7 in detail please or point me to links if possible.

Thx in Advance
Sat

View 3 Replies View Related

SQL 2K Backup Log Monitoring

Jul 23, 2005

Greetings,I'm looking for a little guidance. I work for a medium sized bankwith about 20 SQL servers in 2 locations. We have two backup schemes -Less critical SQL boxes have nightly DB backups and Transaction Logdumps, more critical boxes have additional hourly transaction dumps.The database maintenance should be deleting any backups more than 2days old (Should have been picked up by system backups and moved to SANby then).My question: Sometimes the SQL backups fail, usually for lack ofdisk space. As it stands now it's a tedious process of reviewing thelogs of each of the 20 servers to check for failure. Is there a productthat can centralize these logs or give meaningful errors on failure?I'm not real keen on using the email/pager reporting function fromthe DB Maintenance. We have 4 techs who rotate on reviewing the logsand we don't want to receive unnecessary emails 75% of the time or haveto change the account info every week.Any suggestions would be appreciated.Thank,Jim

View 1 Replies View Related







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