# Not able to set reflection

**URL:** <https://community.dremio.com/t/not-able-to-set-reflection/2233>\
**Category:** Uncategorized\
**Created:** [November 12, 2018, 2:02pm UTC](https://community.dremio.com/t/not-able-to-set-reflection/2233 "2018-11-12T14:02:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vikash\_Singh](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vikash_singh/32/1069_2.png) [@Vikash\_Singh](https://community.dremio.com/u/Vikash_Singh)\
**Post date:** [November 12, 2018, 2:02pm UTC](https://community.dremio.com/t/not-able-to-set-reflection/2233/1 "2018-11-12T14:02:18Z")

</div>

i am running dremio on kubernate and connected SQL server as data-source after that when i am setting reflection after that i hangs saying reflection in progress

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/b/b9aca47d807241180e47dc794d6a3101567be9c9.jpeg)

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [November 12, 2018, 3:03pm UTC](https://community.dremio.com/t/not-able-to-set-reflection/2233/2 "2018-11-12T15:03:18Z")

</div>

Hi @Vikash_Singh

Would you know,

1. How big the SQL server table is?
2. How many executors you have?
3. What is the # of CPU’s on each of these executors?

Can you please send us the profile? Below tutorial talks about how to download the profile

[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![Vikash\_Singh](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/vikash_singh/32/1069_2.png) [@Vikash\_Singh](https://community.dremio.com/u/Vikash_Singh)\
**Post date:** [November 12, 2018, 3:43pm UTC](https://community.dremio.com/t/not-able-to-set-reflection/2233/3 "2018-11-12T15:43:54Z")

</div>

1. How big the SQL server table is? -\> its of 10k records
2. How many executors you have? --\> only 1
3. What is the # of CPU’s on each of these executors? I have ass[b61bd4a7-b777-4466-a2fa-ed8a7784c4db.zip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/311bc3b56a5f171b1167c777ae907b121cb2c328.zip) (6.5 KB)  
igned 8GB RAM,1 CPU

---

<div class="post-metadata">

**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\
**Post date:** [November 12, 2018, 6:49pm UTC](https://community.dremio.com/t/not-able-to-set-reflection/2233/4 "2018-11-12T18:49:56Z")

</div>

The profile you attached is of a query, do you have one for the reflection creation?

Additionally, I wouldn’t necessarily say it’s “hanging”. It seems like it’s still processing and may be taking awhile. It may be worth noting your executor node is really small and undersized, it is below our recommended minimum requirements - [https://docs.dremio.com/deployment/system-requirements.html#server-or-instance](https://docs.dremio.com/deployment/system-requirements.html#server-or-instance)