SQL 7.0 And PerfMon
Apr 7, 2000
I have a SQL 7.0 environment with 5 servers running SP1. I use an NT4.0 workstation with a copy of 7.0 installed on it as my workstation. When I run performance monitor with SQL 7.0 not running on my workstation, I don't see the SQL Server counters. When I have my local SQL 7 copy running on my workstation, they show up, but only when I have my workstation selected for monitoring; when I select another server, they don't show up. Anyone have a suggestion or work-around for this? Makes it kinda hard to monitor my servers remotely...
View 2 Replies
ADVERTISEMENT
Apr 21, 1999
I have a sql6.5 sp4 on nt sp4, the counters for sqlserver are not listed in performance monitor when I use [start][programs][administrative tools][performance monitor] and choose the sqlserver machine. I also get flat lines on the counters that are built in to sqlserver performance monitor and can't add any counters, as none are available. It should not be flat lined as there are 200 users on the system. How do I get the sqlserver counters in perfmon? If a reinstall is necessary, should it be NT or SQL?
View 2 Replies
View Related
Aug 7, 2006
I'm running a % Processor Time on _Total (all processors) on my sql server. In perfmon, the graph of the processor will be going along, stop and then continue on, leaving gaps in the line on the graph. I do get an occasional message telling me there was a problem with the "sampling."
I'm wondering if the stop/start behavior is an indicator of some type of performance challenge. These "gaps" in the processor line do correspond to decreased performance but I can't correlate them to anything. If I look at Current Activity/Process info it doesn't look like anything unusual is going on.
Any ideas?
View 1 Replies
View Related
Mar 23, 2006
Hi
I have to give a report out stating the Min,Avg & max values of the memory utilization .
Now when I run the perfmon it shows me the values , but these are dynamic , I have to get theses values at the end of 8 hours of the shift ....
How can that be done , does anyone have any link to some tutorials or some explanation plz
Thanks
View 1 Replies
View Related
Mar 17, 1999
I am not showing any sql objects when trying to monitor my sql server through perfmon. This is the situation when running NT perfmon or SQL perfmon locally on the server or from a workstation through the network. I have found some tech net articles but they all say that the ojects should exist locally on the server. Any ideas?
Thanks David
View 1 Replies
View Related
Feb 9, 2007
Hi Experts,
Below are some counters from perfmon. Can anybody tell me what should be the acceptable figures for each count?
MemoryAvailable MBytes
MemoryPages/sec
Network Interface(Broadcom NetXtreme Gigabit Ethernet)Bytes Total/sec
Paging File(??D:pagefile.sys)\% Usage
PhysicalDisk(2 H:)Avg. Disk Queue Length
PhysicalDisk(2 H:)Disk Reads/sec
PhysicalDisk(2 H:)Disk Writes/sec
PhysicalDisk(5 F:)Avg. Disk Queue Length
PhysicalDisk(5 F:)Disk Reads/sec
PhysicalDisk(5 F:)Disk Writes/sec
Processor(_Total)\% Processor Time
SQLServer:Access MethodsFull Scans/sec
SQLServer:Buffer ManagerBuffer cache hit ratio
SQLServer:Databases(_Total)Transactions/sec
SQLServer:General StatisticsUser Connections
SQLServer:Locks(_Total)Average Wait Time (ms)
SQLServer:Locks(_Total)Number of Deadlocks/sec
SystemContext Switches/sec
SystemProcessor Queue Length
Thanks
Sachin
Don't sit back because of failure. It will come back to check if you still available. -- Binu
View 1 Replies
View Related
Aug 18, 2000
Are reports you can generate when obtaining data from a perfmon log based on an average or cumulative data. If on an average how is the average calculated?
THanks
View 2 Replies
View Related
Nov 28, 2001
At my company we recently needed to reload SQL 7 on one of our production servers. We then loaded SQL SP2 on it. Later we realized that none of the perfmon counters are showing up for SQL. I tried the whole unlodctr and lodctr routine but it didn't help. Anyone have any suggestions on how to fix this? Any help would be much appreciated.
Best,
John
View 2 Replies
View Related
Sep 8, 1998
I am working on a machine with SQL server 6.5 that is missing the SQL Server performance monitor counters that link in with NT`s performance monitor. The performance monitor itself seems to function ok. But I can`t check SQL server`s performance using the built in objects.
I`m told, a few months ago, this same problem was occuring. At that time, they did a reinstall of SQL and the counters remained missing. So they rebuilt the server from scratch, starting with a new OS install (NT server 4.0). The counters were there after the rebuild.
About that time, they were also encountering database corruptions (page allocation problems), that went away after the rebuild.
Now, the performance monitor counters for SQL have mysteriously disappeared again. Also, data corruption errors are beginning to show up.
I`ve searched MS knowledgebase and found some suggestions. I`ve tried re-registering using the commandline option of "RegistryRebuild=Yes" on setup and I`ve also checked the permissions on the registry keys. Nothing has helped so far.
Has anyone encountered this problem before and is there anything to do besides rebuild the computer? I don`t want to bother rebuilding if it`s just going to fail in a few months anyway.
Some other characteristics about the system. It`s a huge database (9Gb) and there is disk compression on the data device. I am now in the process of removing compression, because I`m sure it can`t be helping SQL.
Thanks in advance,
Jamie Birger
View 1 Replies
View Related
Oct 15, 2004
Ok, I'm really stumped on this one and I'm hoping someone can shed some light on this. I was using PerfMon to monitor SQL Recompilations (SQL Re-Compilations/Sec counter), and found that there were small spikes of about 3 or 4 re-compilations every minute. Probably nothing to lose sleep over, but I thought I would investigate further to see if I could eliminate the cause.
So I ran a profiler trace, which included the SP:Recompile Event, but it came up empty. Kind of odd, so I ran both PerfMon and Profiler concurrently to see if the event would show up in Profiler when the graph spiked in PerfMon. I saw the PerfMon graph spike, but Profiler didn't pick up anything. I double-checked my Profiler settings by running a test script that would cause a recomplile (interleaved DDL and DML statetments) and Profiler correctly picked up the event.
Does anyone have any idea why the two tools would report different results?
Thanks,
Roby2222
View 4 Replies
View Related
Jan 28, 2008
Does anyone have a completed script that will import Perfmon logs from csv format into an existing database that follows the SQL Log File Schema EG; CounterData, CounterDetails, DisplayToID tables accurately. I don't know enough T-SQL to get it right. Thanks for any input you may have.
View 5 Replies
View Related
Dec 13, 2007
I am training to be a DBA in a company running about 30 machines with MS SQL Server (2000 and 2005). Last week I went to a class where the instructor recommended establishing a performance baseline using windows performance monitor. He also advised to run perfmon remotely so as to not effect the performance.
What I am wondering is since I have so many different machines to baseline, can I run perfmon on one box, using a seperate counter log for each server? I would like to get a nice week-long baseline for each machine, but I also don't want to get bad data by running too many logs at the same time.
My plan is to do a small set of counters for processor, memory, disk, and the SQL server instance(about 10 counters total).
If anyone has experience in this area, I would appreciate any advice that you might have.
Thanks,
Matt
View 1 Replies
View Related
Jun 13, 2000
My question is, My perfmon counters reads anywhere between 0 and 1200 with the average being around 250 faults/second.
My concern is my memory max size being too large, I have 4gb ram, SQL reports usage at 2.9 GB, my max mem size is 3.9 gb, should I maybe set my SQL server to use a fixed memory size of 2.9 gb?
Thanks in advance
Pete Karhatsu
Copied from SWYNKs' article:
Process: Page Faults/sec
If this value is greater then 0 then the SQL Server process is producing soft page faults and as a result CPU overhead. Try setting the working set size value to be as close to the SQL Server's memory allocation.
View 1 Replies
View Related
Jul 23, 2005
Recently, using PERFMON, I've been rather dismayed to find that ourapplication is averaging 3 - 4 lock timeouts per second, andfrequently has extended periods of several minutes where this figurereaches the hundreds.Average LockWaits/sec are less than 0.05, and TableLockEscalations/secare less than 0.5These last two seem very good to me, and as a result I wouldintuitively expect a LockTimeout figure of near-zero.Can anyone suggest why the measured LockTimeout value might be so high?Is the measured value actually considered "high" at all? Doubtlessthis depends on a number of things (transaction rate, number of usersetc), but a rule-of-thumb opinion would be welcomed.
View 4 Replies
View Related
May 21, 2007
Hi,
Can anybody explain to me what's going on with my Target memory and Total memory in Perfmon?
Last week, before I upgraded my servers memory, they were both almost the same, at around 24 on the graph. Target was just fractionally above total, but there was almost no space between the two.
Then I doubled my servers memory to 4GB and expected to see total go way up and target stay the same. However, target went up to 72, and total came down to 16. When I looked this morning, target is now around 47 and total is 25.
I guess I expected these numbers to fluctuate, but not as much as this, and also why is there now such a big difference between target and total?
Thanks
Colin
View 7 Replies
View Related
Jun 22, 2007
I have a SQL Server 2000 cluster running on x64 OS. I found the threads in the forum to run perfmon locally by using the x86 version of perfmon (mmc /32 perfmon). However, I cannot run a perfmon remotely from another machine and see the SQL Server perfmon data on any of the nodes in the cluster. The remote perfmon picks up all of the other perfmon variables but no SQL.
I found another thread where somebody asked this question but it wasn't answered. Thanks in advance.
Mark
View 4 Replies
View Related
Mar 2, 2004
Have a sql 2000 db which I have no say in design, just make it run. My typical sql counters such as system queue, and buffer cache and cache hit ratio are all good. If I need to monitor disk activity (mainly how fast my data is being read, how long the user is waiting for that data for both reads and inserts), what are the best counters for this, and what value should throw up a red flag.
View 1 Replies
View Related
Jul 28, 2015
We are collecting perfmon counters every 15 second . Among the counters is Average Disk sec/Write . I under stand that it is the average time taken in second to write a data to the disk. However I do not understand what the is quantum of data written in one second. What is the measure or unit of data in Average Disk sec/Write or is it simply the average time taken for an I/O write request.
View 4 Replies
View Related
Apr 20, 2015
Im backing up to a network directory thats actually a mount point on a different server.My backup was slower than usual so i opened up perfmon to have a look.
When selecting the mount point from the Logical Disks section in perfmon i can see that writes/sec & write bytes/sec both show zero for a long period of time, even though the backup percent complete is increasing.Then all of a sudden the writes to the network share jump massively.
Is there some caching mechanism for backups in sql where during a backup data is only flushed to the disk periodically during backup?
View 1 Replies
View Related
Feb 7, 2007
I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why?
Thanks
View 3 Replies
View Related
