How can we help you today? How can we help you today?
Chris Spencer
Activity overview Badges (0) Posts (0) Comments (301)

Comments

Sort by recent activity
Hi Srikmr I have investigated this and I can only recreate your problem when I insert the data into the sql_variant column without a convert/cast. INSERT INTO DateTimeInVariant (description) VALUES ('2007-05-17 10:11:12:11') GO Without the cast it seems that SQL Server and SQL Data Compare believe the base data-type of the sql_variant column to be nvarchar. Therefore the data is detected as being different If a CONVERT is used... INSERT INTO DateTimeInVariant (description) VALUES (CONVERT(DATETIME,'2007-05-17 10:11:12:11')) GO ...the base data-type is detected as being datetime and the data is reported as identical. SQL Data Compare should be able to compare DATETIME data of any format. I will get back to you regarding point 2 and the API coding. Best Regards Chris / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Format difference of data in sql_variant datatype.
Hi Srikmr I have investigated this and I can only recreate your problem when I insert the data into the sql_variant column without a convert/cast. INSERT INTO DateTimeInVariant (description) VALUES...
0 votes
Just a note to say that we've reproduced this issue in-house and have logged it in our bug tracking system as a candidate for the next release Many Thanks / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Order of table syncronization
Just a note to say that we've reproduced this issue in-house and have logged it in our bug tracking system as a candidate for the next release Many Thanks
0 votes
It's possible that the Manage Servers page shows the servers as connected because that would indicate healthy connections between the base monitoring service and the servers being monitored. My thought was that it could be a clock skew difference between the machines that host the web server (either IIS or the one we ship) and the base monitor service. If these two components are on the same machine then I'll have to rethink. It's unlikely to be a javascript issue if it worked previously so we can discount that one I think. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Global Overview does not display servers
It's possible that the Manage Servers page shows the servers as connected because that would indicate healthy connections between the base monitoring service and the servers being monitored. My tho...
0 votes
Okay it looks like both my suggestions were incorrect. I've just discussed this with a colleague and now think it could potentially be a bug whereby the Monitored Servers page is displaying healthy connections (green ticks) when there are actually underlying issues. Would it be possible for you to locate, zip and email the SQL Monitor log files? These should exist on the machine that hosts the web server + base monitoring service. More information on how to find log files on this help page: https://documentation.red-gate.com/page ... Id=2296838 Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Global Overview does not display servers
Okay it looks like both my suggestions were incorrect. I've just discussed this with a colleague and now think it could potentially be a bug whereby the Monitored Servers page is displaying healthy...
0 votes
Hi I can think of two potential issues that would cause this. a) There is some clockskew between various machines in your setup e.g. your web server and base monitor service machine. A time difference of more than 15 seconds can cause authentication issues. b) Your browser doesn't have scripting/javascript enabled. Also Internet Explorer is by default substantially restricted on server operating systems and this can prevent SQL Monitor from displaying any dynamic content. Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Global Overview does not display servers
Hi I can think of two potential issues that would cause this. a) There is some clockskew between various machines in your setup e.g. your web server and base monitor service machine. A time differe...
0 votes
Hi This alert will be raised when the difference between the Base Monitor clock time and the monitored server clock time is greater than fifteen seconds. This is important because large time differences between machines can cause authentication issues which will prevent our software monitoring correctly. I hope this helps Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Clock skew alert
Hi This alert will be raised when the difference between the Base Monitor clock time and the monitored server clock time is greater than fifteen seconds. This is important because large time differ...
0 votes
tristans wrote: I'm getting the same message every day at seemingly random times. My base monitor and SQL server are the same machine so I don't see how this can even be possible. Can you please advise on how to fix this alert? First of all, apologies for the very late reply. This does sound a bit crazy. Can you confirm that the SQL Server you mention is the server you are monitoring as opposed to the server that hosts the SQL Monitor data repository? Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Clock skew alert
tristans wrote: I'm getting the same message every day at seemingly random times. My base monitor and SQL server are the same machine so I don't see how this can even be possible. Can you plea...
0 votes
Hi Joona Not all queries make it to the Top 10 Expensive Queries table. The queries are filtered using the following criteria: The Query must have been executed in the last hour Execution count > zero AND one of the following conditions must be true • > 500 ms cumulative CPU time • > 50 executions • > 5,000 cumulative logical reads • > 50 cumulative logical writes • > 50 cumulative physical reads • > 5 seconds cumulative execution time I hope this helps? Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Alert: Long running query and top 10 expensive queries logic
Hi Joona Not all queries make it to the Top 10 Expensive Queries table. The queries are filtered using the following criteria: The Query must have been executed in the last hour Execution count > z...
0 votes
Yes the installer definitely should handle that but it's possible that we have a bug that means that occasionally it doesn't. Good to hear the install worked eventually [image] Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Update from version 3.0 to 3.2 port error
Yes the installer definitely should handle that but it's possible that we have a bug that means that occasionally it doesn't. Good to hear the install worked eventually Chris
0 votes
Our installer just overwrites the existing files. The only real 'upgrade' done is to the data repository. The way this works could definitely be improved. What version of IIS have you got out of interest? As far as I'm aware, the IIS auto-detection has worked fairly well in the past. Would it be possible for check services.msc to see if "SQL Monitor 3 Base Monitor" is still running? If it is it could be worth stopping it before retrying the installer. The installer should be disabling this service but it doesn't appear to be working correctly in your case. Regards Chris / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Update from version 3.0 to 3.2 port error
Our installer just overwrites the existing files. The only real 'upgrade' done is to the data repository. The way this works could definitely be improved. What version of IIS have you got out of in...
0 votes
Total activity
464
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
163