User Profile
madhav33
Copper Contributor
Joined Jul 27, 2022
User Widgets
Recent Discussions
Performance issue in Production box
Hi Folks, I have one query which will give only 192 records from database tables. In that query multiple SQL views are used. When I am executing that query in Production it is taking 3 mins but when I execute the same query on test environment it is executing in 1 second. To further drill down the issue I ran the execution plan in production box I am getting index scan and no parallelism but in test environment i am getting Index seek and parallelism. all the SQL server properties and database properties are same in production and test box. Please help me to under the issue. Regards Sachin Goel1.3KViews0likes3CommentsApplication performance impact post upgrade
Hi Folks, Need technical experts suggestion on an DB performance issue that I am facing after every application upgrade. Here is the current DB setup details for reference: Setup: Database : SQL Server 2014 We have two node active-active cluster with 128 GB RAM and 20 Cores on one node. There are 2 databases (1 production (200GB) and 1 reporting) running on one instance. Replication is configured between production and reporting database. During front end application(.Net application) upgrade, as a defined step we stop the replication, so that no DB synching issue during the upgrade. Once the application redeployed with minor changes as enhancement, we again set back the replication in place and application work fine for couple of hours. Here the issue rises after 8-10 hours of application upgrade and it starts creating issue on performance side like some of the screen/functionality running slow with a 50% degradation on performance. During performance impact we have performed all the necessary health checks on the SQL Server and couldn’t find any blocking in SQL server. Server CPU and Memory utilization also looks normal. This issue get auto fixed in 24 – 30 hours post application upgrade and things back to normal. This issue we are facing post every application upgrade. Help: Can you guys suggest what could be the issue or any other checks that we should perform to find out the root cause.1.3KViews0likes1Comment
Recent Blog Articles
No content to show