Viewing 15 posts - 2,416 through 2,430 (of 22,202 total)
The differences in load is likely the differences in behavior (not necessarily, but, you know how it goes). Those settings were just a couple of examples. I'd examine both sets...
August 7, 2019 at 11:11 am
OK. Most of the work then is going to be with the structures you're building. It's a good idea to know that there are system views (frequently called tables) that...
August 7, 2019 at 12:34 am
I'm not familiar with the app, so no help there.
When you say you don't see it in your QA environment, my inclination would be to first ask what differences are...
August 6, 2019 at 11:47 am
That's going to be tough. We have to define what you mean by "most common" because it's very function dependent. Are you developing a database for an organization? Then the...
August 6, 2019 at 11:41 am
Great to see all the hams.73 to you all
This fight, like so many others, does come down to ignorance. We have to constantly educate ourselves and others.
August 5, 2019 at 10:22 am
Trace can do pretty much all you're looking for. It's just going to put a much heavier load on the system while it collects the data. Also, it's horrific at...
August 2, 2019 at 9:48 pm
You're going to blow it out of the park Brandie. Relax and have fun with it.
August 2, 2019 at 11:46 am
Please try running update stats on the table with the recompile option on the slow DB and run the query again.
Sorry, I'm confused. "update stats on the table with...
August 2, 2019 at 11:15 am
Time to employ extended events and capture the query metrics. That's the single best thing you can do. Identify how long each query takes, how frequently they are called,...
August 1, 2019 at 11:21 am
The same as with any performance problem, you have to gather metrics to identify where the issues lie. I can't tell you what the problem is because other than high...
August 1, 2019 at 11:16 am
Check your databases. Sounds like one is corrupted. Run DBCC CHECKBD on them (during off hours, this is a fairly intensive query).
July 31, 2019 at 12:39 pm
First thing I'd do is understand if you're doing a lift & shift and just moving to Azure VMs, or, if you're implementing Azure SQL Databases or Azure Managed Instances....
July 30, 2019 at 11:03 am
That suggests a strong and distinct difference in I/O behavior. Are the different databases on the different instances on different disks?
July 30, 2019 at 10:51 am
Please, capture the wait statistics for the query on both fast and slow instances. Just running SELECT * over and over isn't going to tell us much unless we gather...
July 29, 2019 at 1:51 pm
Viewing 15 posts - 2,416 through 2,430 (of 22,202 total)