tag:blogger.com,1999:blog-6399552109501991759.post2573293489643139091..comments2024-03-22T01:59:33.431-04:00Comments on SQL Server – performance and other stories: The fastest and agentless performance data collector with Dashboard for Windows and SQL ServerSarjen Haquehttp://www.blogger.com/profile/02299598803627454029noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-6399552109501991759.post-70265196356709104262017-09-07T12:37:13.537-04:002017-09-07T12:37:13.537-04:00It supports only Windows Authentication method.It supports only Windows Authentication method.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-11440797724374015392017-08-24T12:07:10.543-04:002017-08-24T12:07:10.543-04:00Yes i think it took my local account for authentic...Yes i think it took my local account for authentication but what if i want to collect the performance of the server from another domain which i can only authenticate via SQL login Anonymoushttps://www.blogger.com/profile/05186568059025336849noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-2236975420371341502017-08-24T10:50:44.318-04:002017-08-24T10:50:44.318-04:00This is a correct syntax. PerfCollector does not a...This is a correct syntax. PerfCollector does not allow to pass Authentication info on the command line argument. You should have authenticated on the target Windows and SQL Server before hand.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-25505732448794449722017-08-24T10:31:15.024-04:002017-08-24T10:31:15.024-04:00Hello sarjen,
what is the command to monitor and ...Hello sarjen,<br /><br />what is the command to monitor and the sql server (Test-sql2014 ) which is the Default instance on a different domain and i need to pass the sql authentication for that server for PerfCollector.exe running on another machine <br />PerfCollector.exe Test-sql2014 5000 SrvinFlux201:8086 metricsdb SQLAnonymoushttps://www.blogger.com/profile/05186568059025336849noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-53924569178830317222017-08-22T12:18:54.774-04:002017-08-22T12:18:54.774-04:00Okay Thank you Okay Thank you Anonymoushttps://www.blogger.com/profile/05186568059025336849noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-37438649367041550062017-08-22T11:49:14.093-04:002017-08-22T11:49:14.093-04:00We will upload the upgraded version of PefCollecto...We will upload the upgraded version of PefCollector and dashboard very soon.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-86047671228985130302017-08-22T11:43:30.215-04:002017-08-22T11:43:30.215-04:00Hi Sarjen,
I am getting the following error
Found...Hi Sarjen,<br />I am getting the following error <br />Found invalid demo license, it can't be used.<br />Consider changing computer date and time, or<br />Request for a new demo License.<br />Thanks <br />JagAnonymoushttps://www.blogger.com/profile/05186568059025336849noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-13450390198457733962017-08-22T11:26:34.525-04:002017-08-22T11:26:34.525-04:00Found invalid demo license, it can't be used.
...Found invalid demo license, it can't be used.<br />Consider changing computer date and time, or<br />Request for a new demo License.<br />Anonymoushttps://www.blogger.com/profile/05186568059025336849noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-63176249469960925692017-08-02T10:48:09.606-04:002017-08-02T10:48:09.606-04:00Hi
Tried the same, same problem. No log and no ser...Hi<br />Tried the same, same problem. No log and no series created in metricsdb.So this does not seem to work. Any news on this problem?Barroshttps://www.blogger.com/profile/15977262013788936979noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-41219439431596829572017-07-13T19:16:43.466-04:002017-07-13T19:16:43.466-04:00Hi Sarjen,
What the cost on the PerfCollector HOS...Hi Sarjen,<br /><br />What the cost on the PerfCollector HOST based License or Enterprise License?<br /><br />Thanks,<br />Denny-Anonymoushttps://www.blogger.com/profile/11224784549487919428noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-33659043808305256392017-06-04T17:05:43.366-04:002017-06-04T17:05:43.366-04:00HI Sarjen,
Tnak you a lot for this loader. Il want...HI Sarjen,<br />Tnak you a lot for this loader. Il want to use it rather than telegraf which i use and get data,in order to check the dashbords with it.<br />When Launching PerfCollector, no measument is created in metricdb and the perfCollector.log is empty<br />Is there any verbose mode for debug?<br /><br />thank you<br />Mathias<br />Anonymoushttps://www.blogger.com/profile/18330996512208723110noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-57739665230223136312017-05-19T09:47:51.731-04:002017-05-19T09:47:51.731-04:00First install influxdb and create the database, th...First install influxdb and create the database, then run the PerfCollector.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-37639418042503424262017-05-19T09:45:25.620-04:002017-05-19T09:45:25.620-04:00Please make sure that the Grafana and its data sou...Please make sure that the Grafana and its data source has been configured correctly. Note that the InfluxDB data source is case sensitive. You can read www.Grafana.net documentation for influxDB and Grafana configuration.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-18704152848115497272017-05-18T19:35:58.124-04:002017-05-18T19:35:58.124-04:00i create the database metricdb on inflixDB but aft...i create the database metricdb on inflixDB but after this the dashboard didnt give me nothing, do i have to configure another think on my machine?<br />Can you please help me out.<br />ThanksAnonymoushttps://www.blogger.com/profile/10557218517473229488noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-86142244307552032322017-05-18T18:33:27.492-04:002017-05-18T18:33:27.492-04:00Hello this post is great, but i am triying to inst...Hello this post is great, but i am triying to install the metricdb before import the performance metric but i hace an error on the configuration of the metricsdb.<br />the error say: <br />Unknown error<br />InfluxDB Error: undefined<br /><br /><br />Anonymoushttps://www.blogger.com/profile/10557218517473229488noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-23005432019898472752017-04-05T03:14:06.970-04:002017-04-05T03:14:06.970-04:00Hi, please make sure that the port 8086 is open in...Hi, please make sure that the port 8086 is open in the windows firewall. <br />For the second error, please check WMI classes do exits for sql server.Sarjen Haquehttps://www.blogger.com/profile/02299598803627454029noreply@blogger.comtag:blogger.com,1999:blog-6399552109501991759.post-85498963781580556232017-04-03T22:39:02.945-04:002017-04-03T22:39:02.945-04:00Hello,
I like and follow your work on this. I ins...Hello,<br /><br />I like and follow your work on this. I install InfluxDB, Grafana and PerfCollector on my laptop. I am not able to get it running correctly :-( <br /><br />I run PerCollector only Windows and seems running correctly but when I query InlfuxDB with show measurements, I get nothing.<br /><br />When I try to run PerfCollector with Win and SQL i get an error.<br /><br />Hope you could give me some help.<br /><br />Thanks<br /><br />----<br /><br />PerfCollector.exe localhost\l2012 5000 localhost:8086 metricsdb SQL<br /><br />Current license utilization: 1 out of 5<br />Number of granted target servers whih this license = 5<br />License was granted to CIRX153P<br /><br /><br />Windows and SQL Server Performance Data Collector<br />Sarjen Haque, sarjen@gmail.com<br />http:\\sqltouch.blogspot.ca<br />Version : 1.1.0<br />Date : March 2017<br /><br />Microsoft\ Windows\ 10\ Entreprise;\ (10.0.14393);\ 64\ bits;\ LENOVO;\ 20BFS0F400;\ Processor:1\ Core:4;\ Memory:8\ 00\ GB<br />Microsoft\ SQL\ Server\ 2012\ (SP3-CU6-GDR);Enterprise\ Edition\ (64-bit);\ SP3\ (11.0.6567.0);\ Standalone<br />EAccessViolation:Access violation<br />Les albums de BigggAlll sur Lightroomhttps://www.blogger.com/profile/03132596341166978517noreply@blogger.com