# Elastic search configuration for windows server **URL:** \ **Category:** Elasticsearch\ **Created:** [June 26, 2018, 8:00am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378 "2018-06-26T08:00:35Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![saineshwar\_bageri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saineshwar_bageri/32/32688_2.png) [@saineshwar\_bageri](https://discuss.elastic.co/u/saineshwar_bageri)\ **Post date:** [June 26, 2018, 8:00am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/1 "2018-06-26T08:00:35Z")
If I have a data of 20 Million and I want to push into elastic search single instance. - what will be the configuration of the server, I will be using windows server. - Does single instance is enough. - Creating Elasticsearch cluster is mandatory. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 26, 2018, 8:33am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/2 "2018-06-26T08:33:03Z")
May I suggest you look at the following resources about sizing: [https://www.elastic.co/elasticon/conf/2016/sf/quantitative-cluster-sizing](https://www.elastic.co/elasticon/conf/2016/sf/quantitative-cluster-sizing) > **[How many shards should I have in my Elasticsearch cluster? | Elastic](https://www.elastic.co/blog/how-many-shards-should-i-have-in-my-elasticsearch-cluster)** > > Elasticsearch is a very versatile platform, that supports a variety of use cases, and provides great flexibility around data organisation and replication strategies. This flexibility can however somet... > **[NetSecureDay: Managing your Black Friday Logs](https://speakerdeck.com/elastic/netsecureday-managing-your-black-friday-logs)** > > Surveiller une application complexe n’est pas une tâche aisée, mais avec les bons outils, ce n’est pas si sorcier. Néanmoins, des périodes fortes telles que les opérations de type « Black Friday » (Vendredi noir) ou période de Noël peuvent pousser... ---
**Author:** ![saineshwar\_bageri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saineshwar_bageri/32/32688_2.png) [@saineshwar\_bageri](https://discuss.elastic.co/u/saineshwar_bageri)\ **Post date:** [June 30, 2018, 9:35am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/3 "2018-06-30T09:35:24Z")
Hi Dadoonet sir, I have one more query i want to update data in elastic search , what if data to update is 1 Million and which api to use and tools (Logstash) or any other tools. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 30, 2018, 10:01am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/4 "2018-06-30T10:01:31Z")
It depends on what tool you used at first I believe. ---
**Author:** ![saineshwar\_bageri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saineshwar_bageri/32/32688_2.png) [@saineshwar\_bageri](https://discuss.elastic.co/u/saineshwar_bageri)\ **Post date:** [June 30, 2018, 10:15am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/5 "2018-06-30T10:15:32Z")
I am using Logstash with jdbc an it is on windows server. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 30, 2018, 10:39am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/6 "2018-06-30T10:39:42Z")
Then use the same tools to update. Note that if you are going to update a lot of documents, it might be better to reindex the whole dataset instead. ---
**Author:** ![saineshwar\_bageri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saineshwar_bageri/32/32688_2.png) [@saineshwar\_bageri](https://discuss.elastic.co/u/saineshwar_bageri)\ **Post date:** [June 30, 2018, 12:03pm UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/7 "2018-06-30T12:03:12Z")
Hi dadoonet sir, Any documents links for Update API and Re-indexing document. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 30, 2018, 1:01pm UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/8 "2018-06-30T13:01:04Z")
Updating a document is the same API as creating a document. When I say reindex, I meant index again as you did the first time. ---
**Author:** ![saineshwar\_bageri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saineshwar_bageri/32/32688_2.png) [@saineshwar\_bageri](https://discuss.elastic.co/u/saineshwar_bageri)\ **Post date:** [July 2, 2018, 8:06am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/9 "2018-07-02T08:06:38Z")
Hi dadoonet sir, how to speed document insert into elastic search using logstash. Can you give me some suggestion on it sir. I am using JDBC plugin below is the code of it. ``` input { jdbc { jdbc_driver_library => "D:\sqljdbc_6.4.0.0_enu\sqljdbc_6.4\enu\mssql-jdbc-6.4.0.jre8.jar" jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" jdbc_connection_string => "jdbc:sqlserver://SAI-PC;user=sa;password=Pass$123;" jdbc_user => "sa" jdbc_password => "Pass$123" statement => "SELECT * FROM [AdventureWorks2008R2].[HumanResources].[Employee]" } } filter {} output { stdout { codec => json_lines } elasticsearch { hosts => "http://localhost:9200" index => "humanresources" } } ``` ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 2, 2018, 8:43am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/10 "2018-07-02T08:43:16Z")
In my experience, most of time is spent on reading the source database. In that case, you can may be add a `WHERE` clause in your query to select only a subset of your documents and then run multiple logstash pipelines at once in parallel? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 30, 2018, 8:43am UTC](https://discuss.elastic.co/t/elastic-search-configuration-for-windows-server/137378/11 "2018-07-30T08:43:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.