can we use single Dashboard installation for multiple server.

Question

Hi All,

I want to know can i use single sql server dashboard installation for different different server.so we need to in installed this tool on all sql server instances. if anyone know please tell me the step how to configure this for multiple instances.

Regards,

Pawan Singh 

---

Thanks

Answer 1

so we need to in installed this tool on all sql server instances.

Hello Pawan,

And what for a tool are you using?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi Olaf Helper,

I am using sql server DBA dashboard v1. can we use this for multiple instances.

Regards,

Pawan Singh

---

Thanks

Answer 3

Sorry, I don't know this third party tool, so I can't tell you.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

Hi Pawan,

SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. Download SQL Server 2005 Performance Dashboard Reports: http://www.microsoft.com/en-us/download/details.aspx?id=22602.

Single SQL Server Dashboard installation is OK for different servers. After installed it, connect to every instance that you want to see information using the Performance Dashboard and then run the setup. sql script against each SQL Server instance.

Pre-Requisites:
1. You need to have Management Studio installed on the machine where you intend to use the Performance Dashboard Reports (could be either client or server machine).
2. Your SQL Server 2005 needs to have at a minimum SP2 applied (build 9.0.3042 or greater).

SQL Server 2005-Performance Dashboard installation steps:
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/sql-server-performance-dashboard-reports-in-ssms-introduction-install-datediff-error-amp-modified-for-sql-2008.aspx.
http://blogs.msdn.com/b/blogdoezequiel/archive/2009/07/01/sql-server-2005-performance-dashboard-installation-steps.aspx.
 
If you have any problem, please feel free to let me know.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.