March 20, 2009 at 3:56 pm
Hey everyone. I am trying to setup baselines counters on server. I want to write the data directly from perfmon every few minutes or so directly to a sql server database. I have setup the ODBC Data Source and in the test, it works just fine. I setup the count log with no issues. However, when I actually try to start the Log (Called Baseline_Counters) I get the following message:
"The baseline log or alter has not started. Refresh the log or alter list to view current status, or see the application even log for any errors. Some logs and alters might require a few minutes to start, especially if they include many counters or they contain counters to be collected from a remote system that is no longer on the network. For further information see the troubleshooting section in the online help."
I check out the event view > System and see that the log sent a start control, entered a running state, and then entered a stopped state all withing seconds of each other.
Does anyone have any idea on what is going on or what I am doing incorrect?
SS2005 SP2, Windows Server 2003 R2 sp 2
Thanks,
Fraggle.
March 20, 2009 at 5:01 pm
I haven't done this in years, but don't you have to create the output table to hold the data first?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 20, 2009 at 5:13 pm
Are you aware of the fact that all of the SQL Server specific perfmon counters are already available from SQL Server?
SELECT *
FROM sys.dm_os_performance_counters;
If you need to be able to trend these values, then you can easily run a query to insert the data into your table.
For a lot of the other counters, you can use the other dynamic management views:
sys.dm_os_wait_stats
sys.dm_os_latch_stats
sys.dm_io_virtual_file_stats() --needs the right parameters
...etc...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 21, 2009 at 7:59 pm
Those dmv give some of the stuff I am looking for. However it doesn't have everything. I am looking for server statistics as a whole, not just the instance or database.
I actually thought of creating a table. However, I didn't see any place specific to list a table name. Just the database name.
Nathan
March 21, 2009 at 9:38 pm
Yeah, the table name is pre-set also.
As I recall that's the whole trick to setting this up, you have to find the tables name(s) and defintions and define them ahead of time. Yet for some reason it is hard as heck to actually find this information. I think I found it in a Technet article many years ago. Sorry, I do not have it now.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2009 at 9:48 pm
OK, supposedly it will create the tables for yo, however, you have to make sure that the account it runs under has the permissions to do that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2009 at 10:12 pm
I will have to take a look through Technet then. The account has administrator rights.
Let me know if you think of anything else.
Thanks,
Fraggle
March 22, 2009 at 12:01 am
What rights does it have in SQL Server?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 23, 2009 at 7:23 am
The ODBC connection that I setup uses a loging has administrator rights in sql server.
Creating a table didn't help either.
Fraggle.
March 23, 2009 at 7:32 am
Huh, well I'm stumped. Maybe it's something else entirely?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 23, 2009 at 7:39 am
Damn, and I haven't had much luck finding anything on that article in Technet you were telling me about.
Let me know if you think of anything else. I will keep searching.
Fraggle
March 23, 2009 at 8:52 am
Here's a previous SSC Thread that has some tips that may be relevant: http://www.sqlservercentral.com/Forums/Topic308383-5-1.aspx#bm308596%5B/url%5D.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 23, 2009 at 8:59 am
Hmm, not sure that helps much...
I still have the strong suspicion that this is logon/security/permissions/authentication related somehow. Can you try to setup your ODBC connection to use a SQL Login instead?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2009 at 11:36 am
I have tried both Windows Authentication and Mix Authentication. I have also tried using the SA login/password for it, just to verify that it wasn't an issue there. Still, I get the message.
I have even lowered the amount of counters to 1, just for testing purposes on the off chance it was there as well.
At this point, unless someone has a better idea, I will try setting up an SSIS package to deal with it.
Fraggle.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply