: I am trying to index data from SQL Server view to the SOLR using the DIH
Have you ruled out the view itself being the bottle neck? Try running whatever command line SQLServer client exists on your SOLR server to connect remotely to your existing SQL server and run "select * from view" and redirect thek output to a file. that will give you a minimal absolute baseline for the best possible performace you could expect to hope for when indexing into Solr -- and tip you off to wether the view is the problem when asking for more then a handful of documents. -Hoss