MSDE And Missing Perf Counters
May 15, 2002The SQL performance couters do not get installed with MSDE. Does anyone know how to install them??
View 2 Replies
ADVERTISEMENT
Missing SQL Perfmon Counters
Nov 28, 2001At 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
Missing Perfmon Counters From SQL 6.5
Sep 8, 1998I 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
Missing Performance Counters
Aug 14, 2002Hi all,
I have sql 2000 enterprise. From performance monitor, the sql counters are missing. During installation I've made sure that the sqlcounters are installed. The sqlctr80.dll is installed. But still the counters are not showing.
Has anybody come across this, not sure what to do next
Missing Performance Monitor Counters
Jul 9, 1999The SQL server perfmon counters are missing from one of my MSSQL 7.0 servers - they do appear in others just fine.
Can anyone tell me what is wrong and/or how I can add the counters? I have seen archieve notes on this topic but can't access them for some reason (page appears blank when I click on link)
I am using perfmon to remotely monitor the problem server. My login has sysadmin permissions and is an NT admin. on both the server and the monitoring client. The login account for MSSQL server and SQL Agent services are both sysadmins.
Many thanks
Missing Counters In Performance Monitor
Aug 20, 2003Im missing all SQL Server counters in the Performance Monitor
and have looked at article: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q196/6/57.ASP&NoWebContent=1
but this article refers to SQL 7...I have 2K with SP3 and MS03-031
How can I get my counters ? thanks
SQL 2012 :: Every Time Machine Is Rebooted Performance Counters Are Missing?
Mar 24, 2015SQL Server 2014 BI
Windows 2008 R2
Every time machine is rebooted performance counters are missing.
select * from sys.dm_os_performance_counters returns no records. I execute "lodctr" command and get it back every time.
I would like to know the route cause of this issue, why it gets removed every time the machine is rebooted.
Perf Mon
Mar 15, 1999On an installation of sql 6.5, when I go to performance monitor, there are no sql counters. What gives? How can this be fixed,and do I have to reinstall,(wipeout data) to do it?
View 2 Replies View RelatedSQL Perf Mon
Nov 9, 1998The User Defined Counters Object has disappeared from me Performance Monitor.
Any ideas why or how to get it back? Thanks, Mike
Perf Monitor
Feb 24, 2004Is there anyway that you can automate performance monitor from the cmd line. I.e feed it some parameters like server and counters and receive a log file at the end.
Cheers
SQL Network Perf Issues
Mar 19, 2003I have a SQL2000 db running a vendor custom app on a Win2000 sp3 server. The front-end is run on Citrix to the client. Can't change the app or the somewhat poor infrastructure of client. users starting to complain about slowness ( we can shadow them and this seems the case). On the SQL box all the standard perf counters look good (buffer cache at 100%, queue length always less than 1, memory and disk look good. The server currently has 2 nics doing load balancing. The network counter bytes/sec averages over 100,000. The network counter output queue length shows an average of 4,294,967,251 (That seems high but in reading on another sql perf site this counter doesn't always work). Any other ideas where I might look. Do these numbers look high?
Thanks
Perf Report Query
Sep 22, 2005CREATE TABLE [Perf] ([TransId] INTEGER,[FileNo] VARCHAR(80),[TimeInSeconds] INTEGER,[FileSizeMB] INTEGER,[FileName] VARCHAR(255),[StartDate] datetime)Ok!! Here's the Problem. I am working on a perf stats report. FileType is First 9 chars of the field FileName. I need to compare a similar filename from this month to last month or before ordered by file size. Maybe this is a very simple query but currrently my mind refuses to work. Seeking F1.
View 3 Replies View RelatedSql 2000 Perf Monitoring Books
Mar 23, 2004Any recommendations from DBA's on good books for performance monitoring for sql 2000
View 2 Replies View RelatedPerf Tuning Question - Gurus Only
Feb 19, 2004Howdy
I have a server that has the following average readings :
No. CPUs = 1
% CPU = 2
SystemCPU Queue Length = 2 to 4
SQL Server:Buffer ManagerBuffer Cache = 99.85%
RAM in the box = 1 GB
MemoryPages/sec = 1 to 5
SQL memory in use ( using Task Manager ) = 250 MB
Max worker threads = 255
Average number of connection = 60
So...........all indicators are that the CPU is idling, there is way enough RAM but we still have a ( in theory ) a congested CPU as the queue length is over 2 consistantly. Thing is, I need to work out if the CPU isnt working hard as the queue is long, or whether we can put extra databases/load on the box.
As the max worker threads are greater than number of connections ( 60 vs 255 ) we could reduce these as the number of users doesnt seem to alter much. BUT.......would this make much difference as if the 255-60=195 worker threads arent doing anything much, they shouldnt put any load on the server, right?
Any thoughts much appreciated.
Cheers,
SG.
High Value For The PagesSec Perf Counter
Feb 26, 2008Hello All,
I have a 64-bit SQL Server running on 64-bit OS having 12GB of RAM. The Server only hosts our Application database (its a 30 GB database). There are no major process running on it. Despite of this, the Avg Pagessec shows a count of 1500 and
the Avg Page Faultsec shows 22000. Is there any specific reason as to why this is happening? The %idle time of the disk is 87%. Also there is no major load on the server. Do let me know if you need any other input.
Thanks in Advance,
Mitesh
Perf On Read Uncommitted Isolation Level
Jul 5, 2005Are there really any benefit on using Read Uncommitted Isolation Level or having a NOLOCK hints for retrieve queries when the default Isolation level just Read Committed (not using COM+). I'm confused why the Community Server uses this technique perhaps for perf issues but I couldn't see any reason why...
View 1 Replies View RelatedSSIS Perf Tuning - Tables Of 15M+ Rows
Feb 28, 2008The challenge: I have to extract and convert data between 2 SQL server systems - only 4 tables on the source systems, 8 tables on the target system. Source tables have between 5,000 rows and 16,000,000 rows. For most of the tables (for example Customer, which goes into 4 target tables), there will be 1 row in target tables for each row in the mapped source system table - so my 13.5M customer rows will end up as around 40M rows across the 4 target tables. So far, so good. But - this is a 24x7 online retail web-site, and to get the data across as a clean process, we require the smallest possible duration.
I have progressed on the customer migration, and am testing on a test environment (2xdual core HT processors, 4 GB ram) which was 2.15 million rows. Live environment is likely to be a 4xdual core with 8-16 GB ram.
I am trying to optimize the extract data flow, and have read the SSISperfTuning doc. I am now trying to put that into practice.
I have a row size of approx 340 bytes, so based on that, and my test environment of 2.15 million rows, I work out at around 700 MB ram required to buffer the data. That is a factor of 7 times greater than the max buffer space for a data flow of 100 MB, which it seems, means I should divide the base MaxBufferRows (10000) by 7 to go down to 1400 rows?
I see a LOT of the following messages in my progress, when running with default settings:
[DTS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 30 buffers were considered and 30 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.
The design of the data flow at the moment is:
..........................................|--target table 1
SOURCE SP ---- MULTICAST---|--target table 2
..........................................|--target table 3
..........................................|--target table 4
any thoughts on Buffer tweaking, corrections to my assumption and other hints/techniques?
*##* *##* *##* *##*
Chaos, Disorder and Panic ... my work is done here!
2005 Perf Much Worse Than 2000... Suggestions Please..
Nov 20, 2006I have this SP that takes several varchar columns and concatinates them all together then inserts them into a text field. I do this with a cursor which was the quickest way to get it done when it was setup...
However when I moved the process to a 2005 server (on the same physical server) the process drastically slowed down. On 2000 the process took about 7 min to handle all 350k+ rows with the processors hanging around 20-40%... On 2005 it took over 30 min (not sure how long it would take cause I killed the process) and the processors stay above 98%...
I have rewritten the process to use a while loop instead of the cursor (I wanted to do this anyways) and it had no effect. At this rate (about 1 row a second) it will take forever and this process runs everyday.
Any ideas??
Here is the procedure...
declare @srch_field varchar(8000)
declare @row int, @productid varchar(25)
DECLARE @title varchar(150), @actors_keyname varchar(1200), @directors_name varchar(400)
Declare @genres varchar(700), @theme varchar(1500), @type varchar(1500), @studio_desc varchar(100)
DECLARE @media_format varchar(50), @artist_name varchar(100), @dev_name varchar(100)
DECLARE @flags varchar(256), @starring varchar(256), @esrb varchar(100), @esrb_desc varchar(500)
DECLARE @ptrval varbinary(16), @text varchar(max)
declare @productlist table(product_id varchar(25), IDNUM int identity)
insert into @productlist (product_id)
select product_id
from music_load..globalsearch
select @row = @@rowcount
while @row > 0
begin
select @productid = product_id
from @productlist
where idnum = @row
SELECT @title = rtrim(title) ,
@actors_keyname = actors_keyname ,
@directors_name = directors_name,
@genres = genres ,
@theme = theme ,
@type = type ,
@studio_desc = studio_desc,
@media_format = media_format ,
@artist_name = artist_name,
@dev_name = dev_name,
@flags = flags ,
@starring =starring ,
@esrb = esrb ,
@esrb_desc = esrb_desc
FROM globalsearch
where product_id = @productid
Set @srch_field = isnull(@title,'')
if @actors_keyname is not null and @actors_keyname <> 'unknown'
Set @srch_field = @srch_field + ' ~ ' + rtrim(@actors_keyname)
if @directors_name is not null and @directors_name <> 'unknown'
Set @srch_field = @srch_field + ' ~ ' + rtrim(@directors_name)
if @genres is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@genres, 0,''))))
if @theme is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@theme, 0,''))))
if @type is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@type, 0,''))))
if @studio_desc is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@studio_desc)
if @media_format is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@media_format)
if @artist_name is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@artist_name)
if @dev_name is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@dev_name)
if @flags is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@flags)
if @starring is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@starring)
if @esrb is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb)
if @esrb_desc is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb_desc)
update globalsearch
set srch_field = @srch_field
where product_id = @productid
SELECT @ptrval = TEXTPTR(srch_field),
@text = credits
FROM globalsearch
where product_id = @productid
UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text
SELECT @ptrval = TEXTPTR(srch_field),
@text = track
FROM globalsearch
where product_id = @productid
UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text
set @row = @row - 1
end
Loading Data Warehouse (Perf. Tuning)
Feb 25, 2008
Hi all,
I'm loading my data warehouse using several SCDs. Some of these SCDs need to occur in sequence, while others can be run at the same time. I'm wondering what the best option for me is in terms of performance. Here is what I was considering:
1) Create a single package. Create two sequence containers --- one that will contain SCD loads that occur in sequence; the other sequence container contains SCD loads that occur in parallel.
OR
2) Create a set of packages for each SCD load. Then create a "Master" package that will use "Execute Package Task" components to call these packages.
The othe reason I want to bring up these difference ways to design an DW Load is because the second option is a "cleaner" approach, or a more organizational approach, to the load. The first option can get quite messy and large if you have several SCDs and several sequence containers. However, I'm looking for the fastest performance. Any thoughts?
Webinar On High-perf Extracts From Oracle, DB2, Teradata, Etc.
Jul 12, 2006This webcast from our partner, ETI, may be of interest to readers on the forum - we see questions quite often about high-performance interaction with other databases.
Donald
2005 Developer - Perf Monitor Counter Check Failed Message
Nov 11, 2006Trying to install 2005 Dev edition in xp pro, sp2.
Performance Monitor Counter Check Failed Error.
Had to stop the install twice at the point it verified what components were to be included as
the docs were not going to be installed. Resolved the issue.
Now it won't pass the system config test because the registry is not the way it wants it.
I look up the messages and the only solution is to hack the registry and risk my system.
This is nuts.
Isn't there some way to restart cleanly without hacking registry keys ?
Help.
Hit Counters
Jul 19, 2006WHy can I not get the hit counter to work on my website. I used WebEasy6 program.
View 1 Replies View RelatedSQL Performance Counters
Apr 23, 2001I am running MSSQL v7.0 with Service Pack 2. I just realized that I have no sql server performance counters on this machine. Does anyone know how to install these performance counters without reinstalling the SQL Server software?
View 1 Replies View RelatedCan't Available MS SQL 7.0 Counters After Installation
Feb 15, 2001After installation of MS SQL 7.0 on NT Server computer counters on SQL server didn't available. On other machine all ok. What can I do for resolving this truble?
View 1 Replies View RelatedPerformance Counters
Apr 18, 2006In the Performance object drop down list of Perfmon.
I don't see the below counter
SQLServer:AccessMethods
SQLServer:BufferManager
SQLServer:Databases
SQLServer:GeneralStatistics
SQLServer:Latches
SQLServer:Locks
SQLServer:MemeoryManager
SQLServer:SQLStatistics.
How to enable these?
Thx
Venu
Perfmon Counters
Feb 9, 2007Hi 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
RESET COUNTERS
Oct 6, 2007Hello All:
i am inserting a counter from a procedure based on the year/month.
I would like to reset the counter to 1 every month.
example of data:
count year/month
_______________
16200711
17200711
18200711
19200711
20200711
21200712 this counter should be reset to 1
22200712
23200712
MY PROCEDURE
____________
DECLARE @i INT
SET @i = 1
DECLARE @DateID INT,
@YMN CHAR(6)
DECLARE c CURSOR
FOR
SELECT DateID,YMN FROM TEST
WHERE WkDayIn = 'Yes' AND HolidIn = 'No'
OPEN c
FETCH NEXT FROM c INTO @DateID,@YMN
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE TEST
SET BusDay = @i
WHERE DateID = @DateID
SET @i = @i + 1
FETCH NEXT FROM c INTO @DateID,@YMN
END
CLOSE c
DEALLOCATE c
Thank You
F.
Alfanumeric Counters?
Nov 20, 2006Hi there,
T-sql 2005 is offering the possibility to define alfaphanumeric counters? I mean, stuff like this: a,b,c...z, a1, b1...zn...a2..
Is it possible or it must be built for yourself?
I'm awared of IDENTITY function when I ran Sql2k but it doesn't target my goal.
Thanks for your time,
No SQL Performance Monitor Counters
Jan 24, 2000Any suggestions on getting them back? Reinstalling SQL didn't do anything. And yes, I am server administrator.
Thanks!
SQL Server Counters Disappeared
Nov 10, 2005On Tuesday the SQL Server Counters showed up in Performance Monitor. Yesterday they were gone. Is there any way they could have disappeared other than someone explicitly deleted them? How would I go about restoring them? Obviously, I'm concerned.
Thanks for the help.
DB Engine :: All Counters Are Zero Or Blank?
Mar 25, 2009I want to use Performance Counter (perfmon) to log SQL Server counters for a performance turning. Therefore I create a log and add some SQL Server counters (SQLServer:Buffer Manager, SQLServer:SQL Statistics...) and some OS counters (Memory, Paging File...). And set Log File Type to a text file (.csv).But when I open this .csv file, all SQL Servers are zero or blank, but other OS counters are correct.If I view those SQL Server counters in Performance Counter (perfmon) directly, they work well.
View 9 Replies View RelatedPerformance Counters On 64 Bit SSIS
Oct 11, 2006On 32 bit SSIS installations, both of the following performance counter objects are visible in perfmon.
SQLServer:SSIS Service
SQLServer:SSIS Pipeline
On 64 bit SSIS installations, only the following is available.
SQLServer:SSIS Service
The SQlServer:SSIS Pipeline counters are nowhere to be found.
Should I re-install? Is this a known issue with 64 bit SSIS?
P.S. Remote or local access administrative access with perfmon makes no difference, the "SQLServer:SSIS Pipeline" performance counters don't appear in the listbox when connecting to Windows 2003 x64 server.
Can't See 64-bit FTS Performance Counters From 32-bit Application
Aug 24, 2007I have a 32-bit application which sometimes runs against 64-bit servers. When it does, I can't read the performance counters published by the FTS service because they're 64-bit only. I get event #1022 from PerfLib in the event log:
Windows cannot open the 64-bit extensible counter DLL msftesqlFD in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe.
Does Microsoft make available 32-bit counter libraries for 32-bit clients of the 64-bit FTS? How do I obtain those bits?
.B ekiM