C# service to gather SQL data

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

Need some guidance here -

Requirement-

I have 1000 SQL servers and I have a scheduled task running on all of those which updates a table with just an integer, let's call it X (its a sum of some numbers). Now the ask is to create some sort of ticker which updates every few mins with the sum of the total of all the X's from all the 1000 servers and display it either on a webpage or a console. So I will need a service that runs centrally and gets this data from all those 1000 servers or service which runs on all the 1000 servers which pushes this info on the central server. Can you please help with do I achieve this.

And remember if this runs centrally then it should be a multithreaded service.

What I have tried:

I am able to gather the info on the servers. Now the only issue to get the information combined and projected.

Posted 4-May-20 3:02am

Member 11955245

Updated 4-May-20 3:57am

PIEBALDconsult

v2

Add a Solution

Comments

CHill60 4-May-20 9:19am

Please do not post in more than one forum - you have already posted this question at C# Service to gather information from SQL - C# Discussion Boards[^]
Also be sure to read the posting guidelines - we need to see what you have already tried

MadMyche 4-May-20 10:23am

1000 servers or 1000 databases?
Scheduled Tasks (Windows) or Jobs (SQL Agent)?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2020-05-04T03:25:00

Solution 1

Maybe you can use ApexSQL Propagate instead of writing a C# application: Multi-database SQL script execution | ApexSQL[^]

Or take a look at this CodeProject article which uses SignalR: SQL Server Notifications on Record Change with SignalR and SQLTableDependency[^]

Posted 4-May-20 3:25am

RickZeeland

Updated 4-May-20 3:51am

v2

Comments

Member 11955245 4-May-20 9:36am

I dont think that is an option, cannot have a third party applications installed on the system.

Dave Kreskowiak · Answer 2 · 2020-05-04T03:51:00

Solution 2

Well, if you can't use 3rd party solutions, you're going to have to write a service that runs on all of the SQL Servers. This service would get the data it needs from the server it's running on and send it to a central SQL database. Your website, or whatever, could run it's query or do its analysis on the data on the central SQL server without having to go through a LOT of time querying 1000 SQL databases for what it needs.

Posted 4-May-20 3:51am

Dave Kreskowiak

Comments

Member 11955245 4-May-20 9:54am

Yes that is what exacty I am looking for. I am not a .Net developer but I know my way around code. So if you have any set of examples which I can refer and write this then it will be very helpful.

C# service to gather SQL data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

C# service to gather SQL data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us