But you are looking for waits. You have a process that is timing out. That means it's running long. Why is it running long? Well, it's not getting the resources...

ffarouqi (7/5/2016)

---

Grant Fritchey (7/5/2016)

---

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job,...

ChrisM@Work (7/5/2016)

---

In addition to everything Grant has said, it's worth noting that the performance of any query depends upon the accuracy of the information which SQL Server can obtain from...

Not really. You can look at create & update dates for the objects (sys.sysobjects), but it won't tell you what the changes are. You can compare between what's currently in...

What has changed? Data? Structure? Code? Settings?

Nothing just randomly changes how it works out of the blue. If a query starts behaving differently, it could be any of the things...

I said all that, and I'm a little wrong. The servers are the same. My mistake.

Define "access to production"

Access to the underlying OS? I worked for 10 years without having that and everything was just fine (one or two minor snags, but nothing worth writing...

Any database created as a SQL Database, is the same. It doesn't matter if you create the database using the portal, powershell or T-SQL. It's a database. Databases live in...

ChrisM@Work (7/5/2016)

---

Grant Fritchey (7/5/2016)

---

If there are differences in structure, are there also differences in the amount of data? Take away different data types and different indexes (which makes comparisons impossible...

If there are differences in structure, are there also differences in the amount of data? Take away different data types and different indexes (which makes comparisons impossible really), just having...

Just reinforcing what Jeff said. The single most important thing you can do, after contacting ESRI directly, is to test this process. Do not assume that anything we tell you...

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job, or that the...

The best bet to do this would be to use one of the many mechanisms for getting the Azure SQL Database to a local server and creating a diagram there....

You basically have to pick a representative time from before and a representative time from after. Could there be outliers? Sure. But presumably, unless you've done lots of other changes...

jasona.work (6/30/2016)

---

I'm wondering if I'm going to be the odd man out here...

My servers, both QA and production, are locked down to where I've not yet seen a "surprise" database....