Comments
Sort by recent activity
I've reinstalled SQL Monitor. No server is monitored but the page still load very slow.
I'm using AMD A8-5600K, 8GB RAM, Windows Server 2003 R2 Enterprise x86. / comments
I've reinstalled SQL Monitor. No server is monitored but the page still load very slow.
I'm using AMD A8-5600K, 8GB RAM, Windows Server 2003 R2 Enterprise x86.
I've changed the purge time to 1 day, disable all custom metrics and then reboot the computer last night.
I need to wait more than 10 sec even at the login page using url "http://localhost:8080"
Only 1 user connecting.
Web and base are installed on the same machine. [image] / comments
I've changed the purge time to 1 day, disable all custom metrics and then reboot the computer last night.
I need to wait more than 10 sec even at the login page using url "http://localhost:8080&quo...
I also get this problem even I update both web and base to 4.0.1.1816. / comments
I also get this problem even I update both web and base to 4.0.1.1816.
Thanks for reply, I've sent the email with config file.
I got the information here: http://www.red-gate.com/supportcenter/c ... omatically / comments
Thanks for reply, I've sent the email with config file.
I got the information here:http://www.red-gate.com/supportcenter/c ... omatically
I've removed build-in\administrators on our SQL 2000, add SQL Monitor service account to MASTER - datareader, MSDB - datareader, but I receive this error:
Monitoring stopped (Incorrect credentials or insufficient permissions)
Server User 'domain\sqlmonitor' is not database 'model' valid user.
Server User 'domain\sqlmonitor' is not database 'model' valid user.
EXECUTE user permission on object 'xp_sqlagent_enum_jobs',database 'master'，owner 'dbo' rejected.
database 'tempdb' ，FN_TRACE_GETINFO permission rejected.
P.S.% The error message are translated from Chinese, sorry about that. / comments
I've removed build-in\administrators on our SQL 2000, add SQL Monitor service account to MASTER - datareader, MSDB - datareader, but I receive this error:
Monitoring stopped (Incorrect credentials ...
I've already granted datareader to this account on "model, "master", "msdb" and "tempdb", but it still show the error.
I need to grant db_owner on "master" to solve this problem. However, the error of FN_TRACE_GETINFO still be obtained.
I'm waiting for the next release.
Thanks for help. / comments
I've already granted datareader to this account on "model, "master", "msdb" and "tempdb", but it still show the error.
I need to grant db_owner on "master" to solve this problem. However, the error...
Other then "Fragmented index", does the performance counters such as processor usage, SQL lock wait time, database active transaction work as well without assigning ddl_admin?
Thanks for your reply. / comments
Other then "Fragmented index", does the performance counters such as processor usage, SQL lock wait time, database active transaction work as well without assigning ddl_admin?
Thanks for your reply.
We're using SQL 2000, is that a reason why information is missing? / comments
We're using SQL 2000, is that a reason why information is missing?
Thanks for reply, I create a job which will copy the trace files to another location.
The UI of SQL response is better than SQL monitor, there are more details, icons and color in "Performance Snapshot => Statement", so there're no planning for upgrade. / comments
Thanks for reply, I create a job which will copy the trace files to another location.
The UI of SQL response is better than SQL monitor, there are more details, icons and color in "Performance Snap...