Hi
Could anyone explain me what is meant by Shared SQL Server in detail?
Thanks,
Priyanka Adam
Technology Tips and News
Hi
Could anyone explain me what is meant by Shared SQL Server in detail?
Thanks,
Priyanka Adam
Hello,
In which context have you heard the term "Shared SQL Server"?
I guess it's meant a SQL Server (in the cloud) shared by several different users/companies.
Hi Priyanka
Which means it is an single Server shared between multiple Application/Business Teams..
This Shared Server may have multiple SQL Server instance which has number of user databases
Each databases used by separate Business Teams.
This type Shared SQL Server concept will be in Banking & Telecommunication Domains.
Hi JP,
If i want to monitor one of sql server instance which is shared.
so want to ask do i need install monitoring agent on sql server instance or on shared sql server?
I believe you are referring to "Shared SQL Area".
It's a term related to Oracle database for scalable DBs (similar to federated databases in DB2).
For more information you can go to:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76992/ch10_sha.htm
Just and Monitoring Agent.. Which will monitor and sent alert for all the Instances/DB's on that Shared Box.
If i want to monitor one of sql server instance which is shared.
so want to ask do i need install monitoring agent on sql server instance or on shared sql server?
You dont need to buy momitoring tool to monitor just single instance. You can place various alerts to monitor SQL Server.
Lots of articles
http://www.sqlskills.com/blogs/glenn/how-to-create-sql-server-agent-alerts-for-critical-errors/
http://msdn.microsoft.com/en-us/library/ms187827.aspx
please make sure you read SQL Server errorlog using command sp_readerrorlog to get more information.
hi
No, I am not going to buy any monitoring tool.. i have already.