Pracrically 3000+ records won't load faster unless you have super fast Server as well as Client machine plus a super fast internet and a very fast database server.

If you don't have the above then simply load data on scroll.

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

any possibilty from sql server side.

Please read the link. Data loading from Server side.

You need to write code to fetch the data from database.

You can refer below for serverside process.

Server Side Paging in Bootstrap DataTable using jQuery AJAX in ASP.Net