WMI Error (not Install/uninstall -- Performance Monitor Derived Class)

Jul 28, 2006

Trying to use WMI to monitor a SQLExpress DB and not getting anywhere. In fact, wmiprvse.exe croaks.

Here's the query I'm running from within CIM Studio:
select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSDatabases

(Just did a search for SQL and found this class)

When trying to get an instance, WMIPRVSE throws this exception:
The exception unknown software exception (0xc000000d) occurred int he application at location 0x7814454d.

Ok to that, then another msgBox shows up with a title of

"Multiview Message" and text as below:
Win32: The remote procedure call failed.
An error occurred while attempting to retrieve the list of objects.

Any suggestions on this would be appreciated. Or perhaps another WMI class to use?

(XP Pro SP2, current with the patches; SQLExpress and MSDE both running)

thanks

View 4 Replies


ADVERTISEMENT

Setup And Upgrade :: Activity Monitor Shuts Down If Connect To Instance Its Monitoring With Performance Monitor

Aug 19, 2015

If I'm on a remote machine, meaning a computer not in the WSFC cluster, and I open SSMS 2014, point it to a SQL Instance, and open activity monitor:

1.  I get all the panes and charts except % Processor Time.

2.  Then, if I authenticate to the cluster's domain by mapping a drive with valid domain credentials, I'm free to put performance counters in the Perfmon - - - but SQL Activity Monitor shuts down with“The Activity Monitor is unable to execute queries against server SQL-V01INSTANCE1..Activity monitor for this instance will be placed into a paused state.Use the context menu in the overview pane to resume the activity monitor.

Additional information:  Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(Mscorlib)”

3.  Of course, the Activity monitor can't be resumed via the context menu. Removing counters and closing the perfmon do not work.  I dropped the mapped drive and rebooted the machine.  That brought back 95% of the information in the Activity monitor.

4.  Further experimentation showed that any mapping of drive shares present on the SQL Server to the computer running SSMS cut off functionality of the 'overview' pane in the remote machine's SQL Activity monitor -- the monitor that had been trying to watch the server offering the shares.

View 4 Replies View Related

Performance Monitor Counter Requirement (Error) - Can't Find Perflib To Edit!

Feb 1, 2008

I keep encountering this error when I try to install another SQL Server after uninstalling Express:  - Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
 
The System Configuration Check for Performance Monitor counter registry
value has failed. For details, see How to: Increment the Counter
Registry Key for Setup in SQL Server 2005, in the readme file or in SQL
Server Books Online.  I've looked up the solution and it
says to change the Perflib entry in the register...only I don't seem to
have one! this is highly annoying as I can do nothing to remedy the
situation. Any ideas?

View 1 Replies View Related

Access To TaskHost From Derived Task Class.

Jan 2, 2007

Hi,

for some reasons, I have to get access to the TaskHost during validation and execution. For example, I wanna know, if my task is within a container or not (parent is Sequence).

For the UI during design time, there is the TaskHost parameter. What about the execution time or during validation?

Any hints?

Thanks.

Thorsten

View 12 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

Uninstall/Install

Nov 8, 2007

Hi,

I am wondering if I am going to encounter any problems when I uninstall SQL Server 2005 standard edition and install SQL Server 2005 Express Edition.

I am asking this as I found out today that a project I am developing (have been working on this for a few weeks now) that we're to be using Express edition. I am just hoping that I'm not going to come across any problems by doing this?

View 2 Replies View Related

Install And Uninstall Problem

Aug 18, 2006

I am having very simular problems with installation and uninstallation as Laydee is having.

There had never been another instance of any type installed on my local computer, I installed SQLExpress because we want to begin migrating to something for the future, and after reviewing all the other options out there decided SQL Server 2005 would be the most efficient use of time and resources.

The initial installation was successful, and we were doing well, writing the new GUI in VB6, then decided we would try VB 2005 in order to take advantage of the .NET framework, stored queries, etc. the first time we accessed the database (Thank God it wasn't the production database) it corrupted something, somewhere and we never could get anything to work. In addition, even the sa login on the instance (the only instance, btw) SQLExpress wouldn't work.

Consequently did an uninstall. But it apparently did not uninstall cleanly.

Re-installed, and could not re-create the instance SQLExpress, since the installation package thinks it's still installed.

Uninstalled again, completely. Online E-Book, sample databases, the whole 9 yards. Even went into the program files directory and deleted the associated directory, and did a re-install. Still was unable to create the named instance SQLExpress. same problem, it thinks that instance already exist.

Uninstalled again, deleted the directory, even went through the registry with a fine toothed comb getting rid of anything that appeared to refer to that instance (SQLExpress), which is no easy task since that instance is also the name of the software package. Re-installed. Same game.

We are about to the point of giving up since we have spent so much time just on trying to get the engine installed again properly that we are considering other, apparently more reliable options. To bad. We already bought SQL Server 2005, and it appears it will be sitting in the vault unopened. If something is this unstable we can't risk installing it on the production systems.

So before I have to declare this whole debacle a total loss, anyone have any suggestions?



View 4 Replies View Related

Performance Monitor

Jun 4, 2001

Would the Performance Monitor be the best tool
to use if you wanted to find out how many transactions
are being process a day?

View 1 Replies View Related

Performance Monitor

Dec 18, 2001

Hello all,

I want to know whether any performance monitoring tools/procedure available in market for SQL Server other than Performance monitor, Profiler, Query Ananlzer of SQL Server.

thank you in advance.

regards,
Nana

View 1 Replies View Related

Performance Monitor

May 11, 1999

Hi guys!
Please tell me where is mistake?
I have win.nt workst. 4.0 and SQL Server 6.5 Client Configuration Utility installed.
I open Performace monitor and try to add to chart sql server which already have been registered in SQL Enterprise Manager.
And I have error message: Computer name not found.

Why??????

Thank you.Sev

View 2 Replies View Related

NT Performance Monitor

Oct 14, 1998

Until this week, I had full functionality of SQL Monitor`s capabilities to monitor SQL Server. Now, when I select our Production Server and attempt to `Add to Chart` I am unable to view/select any SQL Server... entries in the `Object` dropdown list box. When I click the down arrow with the Development server selected I DO see all of the SQL Server selections. This inability to `see` the SQL Server functions in the Performance Monitor for the Production server exists regardless of whether I attempt to view them from a Win NT 4.0 Workstation or at the Server`s console. Again, I had full functionality from both locations last week. The logins have not changed. What has changed?

ANY help would be GREATLY appreciated. I need to monitor this system and I`m running blind at the monent.

TIA
Mike Gaudet
Visages, Inc.

View 1 Replies View Related

Performance Monitor

Jan 4, 2001

Help ????????

I have a winnt and sql server 6.5 when i open up sql performace monitor it doesn't show any thing it comes blank when i go to reintialize the sqlserver object is not there i need to know how can i fix it

its urgent

girimanjesh

View 1 Replies View Related

Sql Performance Monitor

Mar 13, 2008

Does anyone know of a good and preferably free sql performance monitor? I feel my site is running a little slowly after some changes i made and i would like to check it out. Thanks.

View 1 Replies View Related

Should I Uninstall MSDE And Install Developer Edition?

Aug 18, 2004

I know people have put up this question before but I wanted some updated feedback.
I just bought Visual Studio Tools for MS Office and it comes with SQL Developer Edition. I am currently using VS.net 2003 and using MSDE with MS SQL Web Data Administrator to build my dbs then export the sql script.
I was wondering if I should uninstall the MSDE and install the DEv Ed so I can develop all the triggers, constraints etc through Enterprise Manager, therefore having a better setup DB. I know you can do all that through code but why reinvent the wheel.
One last question, with the Dev Ed you just export the schema and scripts to a machine with SQL Server installed once the DB is ready for deployment ? Is this correct?
I lied one more question, does the uninstall of MSDE leave much of a mess, what is the best way to get rid of it.
Thanks in advance
Pete

View 1 Replies View Related

Cannot Install SQL Server 2005 After Running Uninstall

Aug 20, 2007

After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.

I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).

Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)

View 3 Replies View Related

Performance Monitor Question

Jul 19, 2000

I am learning about using the Performance Monitor (SQL Server 7.0).

What I am attempting to do, is to create a very simple log and then
see if I can have the information in the log charted back to me.

I create a log containing:
Process - Page File Bytes
System - % Total User Time

The size of the log file created is 122kb.

I am trying to make sure I very careful following the instructions
in the HELP contents info.

I believe I have correctly specified the type of data I am interested
in, the instance I am interested in, and the parent, etc..

Selected the time frame I am interested in using the scroll bars.

Everything seems to work, except for one thing. I get no chart
information.

Any insight, suggestions, recommendations, etc. will be appreciated.

Thanks for your help. It is appreciated.

View 1 Replies View Related

Logical IO And Performance Monitor

Mar 29, 2000

Hi All,

I've been asked to trouble shoot an installation where many stored procedures are performing poorly. Upon examination I've found that the queries in these procs consume a large volume of logical IO (table scans etc). I'm trying to show that this could cause poor performance of the stored procedures as well as degredation of the server as a whole - but I cant find any suitable counters in Perfmon.

Anyone help?

Jim

View 1 Replies View Related

SQL Performance Monitor Problem

Oct 7, 1999

Hi!
When I run the PerformanceMonitor for SQL7 on my computer the Object-combobox shows the SQL-parameters.
But when I run the PerfMon on another computer (with SQL7) these parameters won't show.
Is this a registry-problem or??? What can I do to make these parameters visible???

regards

/Hans Bck

View 1 Replies View Related

Performance Monitor Objects Not Available

Jul 22, 1999

anyone else having issues with the SQL Server 7.0 specific objects in performance monitor not being available from remote locations. I am monitoring our production SQL Server 7.0 machine from my local, development SQL Server 7.0 box. If I try to access the SQL Server objects for the development server (local) I have no problem. If I try to access the production machine's (remote) objects, they are not available in the object drop down. I'm also able to access the development objects from my workstation (third machine) but not production.

Any tips would be greatly appreciated...I would really love to be able to see how well (or not so well) the databases are performing in real time.

Thanks,

David.

View 1 Replies View Related

No SQL Performance Monitor Counters

Jan 24, 2000

Any suggestions on getting them back? Reinstalling SQL didn't do anything. And yes, I am server administrator.


Thanks!

View 2 Replies View Related

SQL 2005 Uninstall/Install Problem WMI Configuration Related

May 17, 2006

Hi,

I'm the following encountering WMI error message when invoking SQL2005 setup.

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342


I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc

Any help is greatly appreciated.

-James Lin

SCC LOG

================================================================

SCCOpenPerformer Added machine: CAPRICORN
RegisterAddCheckArticleCallbackFunction registered callback function

Calling add article callback function for article: WMIServiceWin32OSWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32OSWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 2
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: OSLanguage
Property type: 2
Value: 2
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: SystemDirectory
Property type: 2

Calling add article callback function for article: WMIServiceWin32CompSystemWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32CompSystemWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_ComputerSystem
Property name: NumberOfProcessors
Property type: 2

Calling add article callback function for article: WMIServiceWin32ProcessorWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32ProcessorWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_Processor
Property name: CpuStatus
Property type: 2

Calling add article callback function for article: WMIServiceReadRegWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceReadRegWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_REGISTRY
DefKey: 0x80000002
Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion
Value name: ProgramFilesDir
Registry type: 4

Calling add article callback function for article: WMIServiceWin32DirectoryWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32DirectoryWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from Win32_Directory where name='C:\'

Calling add article callback function for article: WMIServiceCIMDataWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceCIMDataWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from CIM_DataFile where name='C:\'

Calling add article callback function for article: XMLDomDocument
Callback function returned TRUE
Adding Article...
Article Id: XMLDomDocument
Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
RegisterCallbackFunction registered callback function
Callback filter = 0x6

Performing check on local machine CAPRICORN
Connecting to CAPRICORN machine
ConnectServer returned 0 (0x0)
ConnectServer returned 0 (0x0)
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Creating class instance Win32_ComputerSystem
CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0)
Enumerating the first class of Win32_ComputerSystem
EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_Processor
CreateInstanceEnum Win32_Processor returned 0 (0x0)
Enumerating the first class of Win32_Processor
EnumClass of Win32_Processor returned 2147942405 (0x80070005)
Openning namespace \rootdefault
GetNamespace \rootdefault returned 0 (0x0)
Getting method EnumValues in StdRegProv class
GetMethod returned 0 (0x0)
Executing method EnumValues in StdRegProv class
ExecMethod returned 2147942405 (0x80070005)

Processing article WMIServiceWin32OSWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32CompSystemWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32ProcessorWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceReadRegWorking
Scc Error: 50024 (0xc368)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceWin32DirectoryWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article WMIServiceCIMDataWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE

Processing article XMLDomDocument
Scc Error: 0 (0x0)
Error code: 0 (0x0)
Calling callback function for reason: 0x4
Callback function returned TRUE
SccPerformer closed.


View 9 Replies View Related

Performance Monitor - No SQL Server Object

Feb 14, 2000

Hi SQL lovers!

I'm trying to set up Performance Monitor to watch my SQL Servers. There should be an SQL object in the drop down list in the 'Add To Chart' dialogue box in PerfMon. But not for me! What am i missing here?

I've started the saved Performance Monitor file you get with SQL Server and i can see the 5 already added objects (buffer cache etc..) but when i go to add more, there is no SQL Server object - strange!?

Can anyone help?

Immense thanks,
Kyle Henly.
Allegedly a DBA!
Halcrow Group UK.

View 2 Replies View Related

Question To GURU On SQL PERFORMANCE MONITOR..

Dec 19, 2000

Hi,

Till couple of days ago.. I was able to watch different object counters in SQL Server performance monitor..

For some reason now i am unable to see non of the object counters related to sql server in performance monitor..

The error it records in event viewer is as follows..

The description for Event ID[1001] in Source [ SQLCTR70] could not be found.
It contains the following insertion string[s]: SQL Performance DLL Open function failed..


help is greatly appericated...

thanks indeed

jessi...

View 3 Replies View Related

Intresting Question On Performance Monitor

Nov 2, 2000

Hi Everyone...

I cannot see the all the objects related in SQL SERVER Performance Monitor on one of our SQL SERVER..

The thing is before couple of days when i checked i was able to see all the object of sqlserver in performance monitor..

But for some reason I cant see it now..I am able to see only related to operation system..

Can anyone help me out.. to get back the sql server object in performance monitor..

Help is greatly appericated..

Thanks indeed
jessi..

View 2 Replies View Related

SQL Server Items Not Available In Performance Monitor

Jul 6, 2000

We have SQL Server 7.0 running on a NT 4 sp6 server and non of its items track in performance monitor. Under the SQL program tab, when performance monitor is clicked, it comes up and has items for SQL, but they all track as zero. You can "add" other items such as processor items and they track fine. Any ideas???

Thanks in advance!

Ray Peterson
EPA Seattle
206-553-1682
peterson.ray@epa.gov

View 3 Replies View Related

Missing Performance Monitor Counters

Jul 9, 1999

The 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

View 1 Replies View Related

Missing Performance Monitor Objects....

Mar 7, 2001

I need help in anyone with this problem.

I started out with trying to get to know the existing SQL Servers (6.5 and 7.0). I am missing some Performance Monitor objects (ie SQL Server: Buffer Manager, SQL Server: General Statistics, etc). I am surprised that it is missing.

A typical SQL Server setup:
* NT 4 with SP6
* SQL Server 7 (standard) with SP2
* 2gig Mem
* Over 50gig HD

Does any of you ever have this problem? Any solutions? Any answer would be greatly appreciated.

Thanks.

mjt

View 1 Replies View Related

SQL Server Object In NT Performance Monitor

Nov 23, 1999

I am experiencing problems gathering Stats from Performance Monitor on SQL Server. I am running NT4 with SP5 applied, with SQL Server 7.00.699 . My problem is that I can use the "Performance Monitor" under the Microsoft SQL Server 7.0 sub-menu (Start Menu) to monitor the SQL Server Stats on my machine, but I am unable to monitor any of the servers in our enterprise. Performance Monitor does not even list the SQL Server Object. Does anyone have any suggestions please?

View 2 Replies View Related

Missing Counters In Performance Monitor

Aug 20, 2003

Im 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

View 13 Replies View Related

Using Performance Monitor To Dump Transaction Log

Jan 12, 1999

Hi, I am trying to set up an auto dump for Transaction log using performance monitor ( Log space used(%) )... Although I followed the steps, it did not work... can anyone tell me what am I doing wrong ?

1. create an error # using Server/message/New etc...
2. Defined sql exec alert : right click sql exective/manage alerts/operators..
3. Defined performance monitor using add to alert and set Alert if radio botton to over %80.and Run_Program on Alert: c:mssqlinnE 5555 /T /S servername

then I inset 2000 rows is a table I still get :

Msg 1105, Level 17, State 1
Can't allocate space for object 'publishers' in database 'test' because the 'default' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.

I thought what I did is the right thing to do, but it seems that I am doing something wrong, Please help.

Thanks

Ali

View 1 Replies View Related

Missong SQL Counters On The NT Performance Monitor

Mar 11, 1999

Does any one know, how I can add SQLServer performance monitoring counters back on my NT server. For some reason I am missing these counters. I really do not want to reinstall either the NT OS or SQL OS if there is anyway to aviod this.
Thanks

View 1 Replies View Related

Performance Monitor Missing Instances

Nov 4, 1998

I am running performance monitor on a number of servers without any problems, however on one server, when I select SQL Server Log, It does not show a list of the available db's under the instances.

Other counters, say under SQL Server appear fine.

The server is running SQL 6.5 sp 4, I am running the monitor from an NT 4 Workstation, with full administrator rights on the server.

Thanks in advance for any help

(I have tried MS Tech Sup Online and can find no hits for this one)

View 2 Replies View Related

No SQL Server Performance Monitor Counters

Jul 2, 2004

On some of my database servers, there are SQL Server counters in Performance Monitor. On other servers these are not present. How can I turn these on?

I know with the disc counters you need to explicitly enable them:
diskperf -yv

Is there a parallel for SQL Server? I don't remember doing anything to get them working on the servers that have them. All online articles seem to assume that they just exist.

TIA!

View 11 Replies View Related







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