SQL Server 2000 performance counter

Marc Melancon

Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

Jul 23 '05 #1

Subscribe Reply

2083

dbmonitor

Marc Melancon wrote:

Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

What type of performance counters are you after?

There already are quite a few counters in SQL Server. All you need to
do is run the performance option in Control Panel->Administrati on
Tools.

You will need to run this on the computer running SQL Server or you
could run it on another machine with the counters installed as long as
you have connection access rights to the server.

There are variables that you can use to retrieve performance counts
yourself. I use some of these in my shareware application to display
graphs of CPU usage, network IO and disk access. Also, the application
displays the time it takes for the server to return a simple 'SELECT 1'
command.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

Jul 23 '05 #2

MarcM

From what I understand all SQL Server related performance counter in Yukon
will be available internaly and was wondering if the same would be done on
SQL Server 2000 64bit service pack.

It would be useful in my case.

"dbmonitor" <db************ ***@hotmail.com > wrote in message
news:11******** *************@g 14g2000cwa.goog legroups.com...

Marc Melancon wrote:
Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

What type of performance counters are you after?

There already are quite a few counters in SQL Server. All you need to
do is run the performance option in Control Panel->Administrati on
Tools.

You will need to run this on the computer running SQL Server or you
could run it on another machine with the counters installed as long as
you have connection access rights to the server.

There are variables that you can use to retrieve performance counts
yourself. I use some of these in my shareware application to display
graphs of CPU usage, network IO and disk access. Also, the application
displays the time it takes for the server to return a simple 'SELECT 1'
command.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

Jul 23 '05 #3

Similar topics

6774

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

by: Andreas Lauffer | last post by:

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Microsoft SQL Server

4144

SQL Server storing large amounts of data in multiple tables

by: jeff brubaker | last post by:

Hello, Currently we have a database, and it is our desire for it to be able to store millions of records. The data in the table can be divided up by client, and it stores nothing but about 7 integers. | table | | id | clientId | int1 | int2 | int 3 | ... | Right now, our benchmarks indicate a drastic increase in performance if we divide the data into different tables. For example,...

Microsoft SQL Server

14848

HELP - SQL Server Crash ? Memory leak ?

by: Thue Tuxen Sørensen | last post by:

Hi everybody ! I´m maintaining a large intranet (approx 10000 concurrent users) running on one IIS box and one DB box with sqlserver 2000. Currently there is 2,5 GB Ram, 1 1400 mhz cpu and 2 scsi disks installed on the db box. Sqlserver is set to use max 1,4 GB RAM, and the sqlserver does not seem to be using it all.

Microsoft SQL Server

3189

MS SQL stored proc., linked server, DB2, incomplete txfrs

by: mxd | last post by:

We have server 2003 with sql 2000. as a client getting data from an IBM iseries server with DB2 UDB. The connection is through a linked sever with ODBC connection to DB2. If we invoke a SQL stored procedure to txfr data from DB2 to SQL 2000 the stored procedure completes fine but only about 128k of data is txfred out of 6 megs. No errors occur. If we use DTS and import from DB2 to SQL 2000 everything works fine and all the data is moved....

DB2 Database

647

Server Application Unavailable

by: Steve Buster | last post by:

All right, I have read every forum, newsgroup etc about this issue and no one seems to know how to fix it. I am getting a "Server Application Unavailable" exception running my .NET 1.1 application. I use W2K SP4 and have applied the hot Fix KB824146 and KB824105, both IE fixes. I don't have VS installed because this is a Quality Environment. I do have .NET SDK and .NET 1.1 Runtime installed. I can't change my APSNET user to run as...

ASP.NET

1551

ASP.NET Requests Queuing on one server only

by: Dave Pink | last post by:

I support a web server farm of about 80 machines, of which 35 are in Production at any given time. Machines are running Windows 2000 Advanced Server with IIS 5. All 80 machines are configured exactly the same in regards to software, yet only one machine repeatedly shows queuing on the performance counter ASP.NET Requests Queued. No other machines show any queuing at all. The queuing occurs on the machine in question only after it is put...

ASP.NET

2524

Monitoring Server performance from .NET

by: Jonesgj | last post by:

Hi, I have a test box which I would like to monitor CPU usage and run queue during the day. I don't want to buy any 3rd party tool, if I can do it easily, as I only need to monitor the box's performance over a week. I thought I could just create a .Net app or service with a timer that gets back this data every so many minutes..

Visual Basic .NET

1671

detect high server load and switch to text only mode

by: thomasamillergoogle | last post by:

I have a site that sometimes gets extremely high server loads. I would like to make it so if the sustained server load is very high (million page views per hour) then it will switch to text only mode. My question is, what is the most reliable way to detect page views per hour programatically. I do NOT want to read the IIS logs. But writing/reading performance stats from performance counter is ok. I also do not want to slow down the server...

ASP.NET

4595

SecurityException with PerformanceCounter on remote server in .NET 2.0

by: Geoff McElhanon | last post by:

I have been struggling with a security issue that occurs under .NET 2.0, but does not occur under .NET 1.1. Essentially I am trying to open up a performance counter on a remote server and monitor its value. In .NET 1.1 this worked fine, however under .NET 2.0 it fails when I am not an administrator on the remote server. To provide a lean demonstration of the issue, I created the following class: ============================

C# / C Sharp

8969

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9335

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9263

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8210

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6751

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6053

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4570

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4825

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2745

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP