How can i gather a performance data value of SQL server using SMO?
Eg: I want to retrieve the value of counter 'SQLServer: SQL Statistics: Batch Requests/Sec' using SQL SMO.
View Complete Post
I'm trying to install SQL Server 2008 R2 Express, but there is just no way to make it work.
I have tried changing the values in the registry as said
But it does not help, nor can I find all the values that are mentioned.
I have tried most parts of the KB article
But what I could do, does not help, and I cant find the .dat files mentioned, anywhere.
I'm running a Windows 7 installation virutally with Parallels Desktop on a mac for the only intrerst of using VWD/VS C# expresses and the MS SQL Server. I have even tried to just delete the entire windows installation, reinstalling windows again and
then opening IE downloading SQL Server the first thing I do and it still fails as default...
I can't se why it should not work. I mean the system is made by Microsoft just like the programs I'm trying to install, so with even them beeing a missfit, go figure why I'm on a mac. I obviously do not know enough about this stuff to fix the registry,
I've tried lots of different cleaning programs and stuff, but nothing helps, so what do I do? just give up?
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?
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."
Which factor impacts the Transactions/Sec in SQLServer 2005. What could be the reason to get less Transactions/Sec.
After some code changes in the stored procedure, the Transactions/Sec rate has come down.
I have a mirrored instance that throws up 'unsent log' and 'unrecovered log' errors. Everytime it does the I/O activity shoots up. I was wondering what can be done to improve this?
Extra memory? More processing power?
What if I spread the filegroups across different disks? Would this help?
SQLServer:Cache Manager:Cache Pages (Execution Contexts) = 4294967295
What this might mean?
It overflows, but what it might mean …