# Isolation level

**URL:** <https://discuss.elastic.co/t/isolation-level/362818>\
**Category:** Logstash\
**Created:** [July 9, 2024, 7:03pm UTC](https://discuss.elastic.co/t/isolation-level/362818 "2024-07-09T19:03:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raul\_Uria](https://avatars.discourse-cdn.com/v4/letter/r/76d3ee/32.png) [@Raul\_Uria](https://discuss.elastic.co/u/Raul_Uria)\
**Post date:** [July 9, 2024, 7:03pm UTC](https://discuss.elastic.co/t/isolation-level/362818/1 "2024-07-09T19:03:37Z")

</div>

Hi, I´m trying to execute my queries against sql server using "read uncommitted" or "snapshot" isolation level cause I don´t want to lock others while long queries.

I think there is no other way to do that but insert it in sql statemet (example: "set transaction isolation level read uncommitted; select \* from ...") but does not work, locks are adquire in the server for this query.

Is there something in logstash / jdbc / sequel that avoid to use this workarround?

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [July 9, 2024, 9:49pm UTC](https://discuss.elastic.co/t/isolation-level/362818/2 "2024-07-09T21:49:09Z")

</div>

What database are you reading from? Not all databases will support this, and the database library will not support it for all databases.

---

<div class="post-metadata">

**Author:** ![Raul\_Uria](https://avatars.discourse-cdn.com/v4/letter/r/76d3ee/32.png) [@Raul\_Uria](https://discuss.elastic.co/u/Raul_Uria)\
**Post date:** [July 10, 2024, 8:40pm UTC](https://discuss.elastic.co/t/isolation-level/362818/3 "2024-07-10T20:40:54Z")

</div>

I think MS SQL Server is supported, I use it.