SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 querying remote servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Aged Yak Warrior

United Kingdom
529 Posts

Posted - 05/02/2013 :  11:03:41  Show Profile  Reply with Quote
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?

Edited by - mikebird on 05/02/2013 11:51:30
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000