.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

SQL performance monitor error

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
 

I am runninng Alert monitor on SQL 2005 server and got this error:

Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first DWORD in data section is the Windows error code.

Event ID 1023, source Perflib, Type: error

 

Tried to follow MS article, but it did not fix a problem.

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

.


View Complete Post


More Related Resource Links

Wickedly Strange .Net WPF Performance Problem Dissapeers with Windows 7 Performance Monitor Open

  
Hello Everyone, I have been developing one large and complex WPF application for 13 months now, all is going well and especially tonight as I now have some sort of clue or hint to what I have been seing now for quite some time.  Here is the rundown. 1) Running on i5 processor with 4GB RAM and Windows 7 2) The application was developed all in .Net 4.0, WPF C#. 3) It is heavily GUI intensive and also uses Entity Framework Detached for Database Access. 4) Is multi-threaded / multi-tasking. I am a nutcase when it comes to testing.  Since my graphical application heavily depends upon performance and determinsm (please somebody don't start with the C++ vs .Net on here) and has been performing great FOR THE MOST PART.  Every once in a while, I see that the application runs into the weeds for 5 or 6 seconds and the interface is unresponsive.  I have this thing tuned finely too.  Well now toward the end of development I have finally had to face that bug so to speak.  I can force it by clicking spastically on my buttons causing an event storm and making the system update the GUI.  SO!  Great start, I can now cause the problem on a regular basis (for you youngsters that is actually a good thing)!  Alright, so I start with the easiest investigative tool, CNTRL - ALT - DEL into Windows 7 Performance Monitor.  As you can tell from

Performance monitor tools

  
Hi,What is the best tool to continously monitor the performance of the SQL Server, i.e. which queries are the most CPU intensive, which ones are causing most I/O operations etc.. I am not a hardcore DBA and I do not have the time to all the time search for information about which queries are causing the DB-server to run on a very high load. What I would like is to get a report with information about e.g. these are the queries that you should optimize etc..I would really appreciate some recommendations on the best way to continously get information about what is causing the high load on the servers and what can be done to improve the performance.Thanks in advance!Best regardsLars

Performance Point Error

  
HI I have just setup a BI Centre site and when i click on the 'Start Using PerformancePoint Services' link, i get the following error: Error An error occurred during the processing of /Departments/ICT/ICTBI/Pages/ppssample.aspx. Code blocks are not allowed in this file.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 8bad4478-dc69-46cd-b3f3-6ec5035049db Date and Time: 06/09/2010 16:05:22 Does anyone know what to do? I have setup the secure store service, and have set the unattend service account for the performance point services, i have set credentials and made sure in SQL that all accounts i have used have access to the Performance Point DB.

Performance Monitor Counters To View How "Busy" A SQL Server Is

  
What are some good performance monitor counters to look at, when trying to figure out how "busy" our SQL 2008 server is? We were told to look at: SQLServer: SQL Statistics: Batch Requests/Sec and SQLServer: Databases: Transaction/Sec . Any other critical ones? Is there a counter to get the number of  selects, updates, and deletes independently per second? Thanks.

Performance Counters to monitor DirectoryServices.AccountManagement and Security.AccessControl activ

  

Hi Everyone,

I'm writing an application that takes in a file name as input, and then extracts its ACLs using FileSecurity.GetAccessRules().  Once I have these ACLs, I go through and identify each group member, obtain a group principal using Principal.FindByIdentity(), and traverse group principals using GroupPrincipal.GetMembers().  Undoubtedly the first call is going to hit the share where the file is located, and the next two calls are going to translate into LDAP queries against the AD server. 

I'm wondering, are there performance counters that I can attach to on the machine where the code runs so that I can monitor how hard I'm hitting each server?  The thing is that I'm not going to be able to attach a counter to the server iteself.  So Ideally, I would want to know how many bytes I'm sending out of this process per second.  I'm currently using category "Process", counter "IO Other Bytes/sec" to monitor activity.  However, this counter doesn't seem to map 1-to-1 from the data that it reports and the data that Perfmon reports on the network share / AD server.  The mapping seems to be more of a 1:5 relationship, so that when the local process reports that it's sending 10,000 bytes/sec, Perfmon reports that it's getting hit with 50,000 bytes/sec.  Is there a better counter to attach

error on install: Performance counter registry hive consistency check - Status:Failed

  

Hi, I'm tryng to install sql server 2008 in win vista and in the System Configuration Check, item: Performance counter registry hive consistency check has the status FAILED  all the others items has PASSED and the setup stops here theonly option is CANCEL. Thus anyone knows the possible problem and resolution to this?

 

best regards


Performance Counters to monitor DirectoryServices.AccountManagement and Security.AccessControl activ

  

Hi Everyone,

I'm writing an application that takes in a file name as input, and then extracts its ACLs using FileSecurity.GetAccessRules().  Once I have these ACLs, I go through and identify each group member, obtain a group principal using Principal.FindByIdentity(), and traverse group principals using GroupPrincipal.GetMembers().  Undoubtedly the first call is going to hit the share where the file is located, and the next two calls are going to translate into LDAP queries against the AD server. 

I'm wondering, are there performance counters that I can attach to on the machine where the code runs so that I can monitor how hard I'm hitting each server?  The thing is that I'm not going to be able to attach a counter to the server iteself.  So Ideally, I would want to know how many bytes I'm sending out of this process per second.  I'm currently using category "Process", counter "IO Other Bytes/sec" to monitor activity.  However, this counter doesn't seem to map 1-to-1 from the data that it reports and the data that Perfmon reports on the network share / AD server.  The mapping seems to be more of a 1:5 relationship, so that when the local process reports that it's sending 10,000 bytes/sec, Perfmon reports that it's getting hit with 50,000 byte

Disabled performance counter Error with Datasheet views

  

Hi.

Background: WSS 3.0, IE 8.0 , Vista.

Problem: User tries to click on a Datasheet view. IE shuts down. This user seems to be the only one experiensing the problem. Event log has a set of Errors, referring to several services:

"Disabled performance counter data collection from the "WSSMatrixpi" service because the performance counter library for that service has generated one or more errors. The errors that forced this action have been written to the application event log. Correct the errors before enabling the performance counters for this service."

"Disabled performance counter data collection from the "WSSIndex" service because the performance counter library for that service has generated one or more errors. The errors that forced this action have been written to the application event log. Correct the errors before enabling the performance counters for this service."

Tried:

  1. Performance Counter Error

      
    I get this in my Event Log when my service starts up:

    vent Type:    Error
    Event Source:    System.ServiceModel 3.0.0.0
    Event Category:    Performance Counter
    Event ID:    10
    Date:        11/15/2007
    Time:        10:29:06 AM
    User:        xxxxxxxxxxx
    Computer:    xxxxxxxxxxxx
    Description:
    A performance counter was not loaded.
     Category Name: ServiceModelService 3.0.0.0
     Counter Name: Calls
     ExceptionTongue Tiedystem.InvalidOperationException: The requested Performance Counter is not a custom counter, it has to be initialized as ReadOnly.
       at System.Diagnostics.PerformanceCounter.Initialize()
       at System.Diagnostics.PerformanceCounter.get_RawValue()
       at System.ServiceModel.Diagnostics.PerformanceCounters.GetPerformanceCounterInternal(String categoryName, String perfCounterName, String instanceName, PerformanceCounterInstanceLifetime instanceLifetime)
     Process Name: xxxxxxxxxxxx.ConsoleHost.vshost
     Process ID: 1840

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    My config has nothing special in it:

    <diagnostics performanceCounters="All" wmiProviderEnabled="true"> ... </diagnostics>

Error: 29528 -performance counters issue

  

Summary
=============================
you may get the following error while trying to install hotfix:

On setup log:
==============================================
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Installing performance counters.
 The error is: The configuration registry key is invalid.

Resolution:
==============
Check this key

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Performance\Disable Performance Counters

It should be 0.

Open a command prompt window.
At the command prompt, type cd %Systemroot%\System32, and then press ENTER.

At the command prompt, type the following line, and then press ENTER:

unlodctr.exe MSSQLServer
lodctr.exe <SQL Server path>\binn\sqlctr.ini


Microsoft Online Community Support

TSQL to know there is an error in replication monitor (red X)

  

In SQL 2005 and SQL 2008, in the Replication Monitor it will show a red X if any of the subscriptions have an error. Is there a TSQL statement i can run to see that without having to go into the Replication Monitor?

i am trying to come up with some way to see that information and present it to our customer from our application without them having to connect to SSMS and look at the replication monitor.

thanks for you help.


darin

How to Monitor or Evaluate the Performance of .NET Application ?

  
Please let me know the ways to monitor the performance(Memory and CPU Usage) of .Net Windows service application?
Ganesh Chellam Bangalore

Replication Monitor Error

  

Hallo,

after updating a SQL Server 2008 (German) installation to SQL Server 2008 R2 (English), I get an error when I connect to the distributor by using the replication monitor on the same machine. I deinstalled the old version and made a complete new installation.

the error message is: "an error occurd while retrieving the puplisher data" and "Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt"

The last massage is in german, which means translated: "Object reference not set to an instance of an object"

When I open the distributor on this machine from an other machine everthing is fine.

I believe, there is somewhere a library which is still from the previous installation. But where?

Thats how it look like: http://ausgelesenes.de/rm_error.jpg

Server Info ===========================

Microsoft SQL Server Management Studio                        10.50.1600.1
Microsoft Analysis Services Client Tools                        10.50.1600.1
Microsoft Data Access Components (MDAC)                        3.86.3959

ASP.NET Best Practices for High Performance Applications

  
This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

  
Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

  
It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

  
It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend