Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 querying remote servers

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2013-05-02 : 11:03:41
Not Remote Desktop.

I use Head Office with a main DB with a standard schema. I'll hunt through customer logs, given some learning..
Any quick way to automate. Task is about checking, bug fixing terminal sending logs to head ofice to eliminate slowdowns and complaints. No replication used...

Is there an easy way to summarise data transfer efficiency, performance per client server? I'll get into the tables OR SPs... a quick way irrespective of any objects or config...?

Only Express edition at all. I need to flag which issues (log shipping, resource gov) - developers use this edition to make VB do the work. Possible?
   

- Advertisement -