# Approach to irregular performance problems

**URL:** <https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479>\
**Category:** Angular\
**Created:** [January 27, 2021, 4:47pm UTC](https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479 "2021-01-27T16:47:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkfromhighlands](https://forum.radzen.com/user_avatar/forum.radzen.com/mkfromhighlands/32/22078_2.png) [@mkfromhighlands](https://forum.radzen.com/u/mkfromhighlands)\
**Post date:** [January 27, 2021, 4:47pm UTC](https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479/1 "2021-01-27T16:47:31Z")

</div>

Hello there,

now and then we have some performance problems in our application (deployed or localhost).  
Config: IIS Version 10 on Windows Server 2019, SQL-DB on SQL Server 13.

In Chrome Developer Tools, I measured up to 20s of TTFB-time for one pageload. It doesn't matter if it is a complex page with e.g. many invokes for dropdown-datagrids or not.

Furthermore it can happen that when calling a dataset from a datagrid 10 times, no performance problems can be detected. On the 11th time there is again a high TTFB-time.

I am aware that this is hard to define, but maybe you know from experience about problems between IIS and SQL Server or there are tips for a better structuring of pageloads.

Thanks in advance,

Martin

---

<div class="post-metadata">

**Author:** ![enchev](https://forum.radzen.com/user_avatar/forum.radzen.com/enchev/32/16_2.png) [@enchev](https://forum.radzen.com/u/enchev)\
**Post date:** [January 28, 2021, 11:57am UTC](https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479/2 "2021-01-28T11:57:36Z")

</div>

Hi @mkfromhighlands,

Can you check how much time it takes SQL Server to execute the query in such cases? Maybe your server is busy with something else?

---

<div class="post-metadata">

**Author:** ![mkfromhighlands](https://forum.radzen.com/user_avatar/forum.radzen.com/mkfromhighlands/32/22078_2.png) [@mkfromhighlands](https://forum.radzen.com/u/mkfromhighlands)\
**Post date:** [January 28, 2021, 12:51pm UTC](https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479/3 "2021-01-28T12:51:07Z")

</div>

Thank you for your answer, I checked performance monitor on SQL Server while a performance problem occured in the application: nothing special to see. SQL Server is also almost idle since it is part of a testing environment.

Maybe any other suggestions?

---

<div class="post-metadata">

**Author:** ![mkfromhighlands](https://forum.radzen.com/user_avatar/forum.radzen.com/mkfromhighlands/32/22078_2.png) [@mkfromhighlands](https://forum.radzen.com/u/mkfromhighlands)\
**Post date:** [February 8, 2021, 9:22am UTC](https://forum.radzen.com/t/approach-to-irregular-performance-problems/6479/4 "2021-02-08T09:22:55Z")

</div>

Solved!

We had "Enable Session Refresh" in Radzen Security enabled.  
After deactivation, the performance problems are gone.

@enchev: Thank you for your patience!

Regards,

Martin
