Backups are basically all or nothing (although, if you structure your system and have lots of read only data, you can use partial backups and a partial restore). Backups...

I don't know of anyone that breaks apart queries into their component parts for troubleshooting. I'd look to two things to help with this. Instead of capturing batches using Extended...

The DMVs are completely dependent on the cache. That's where the information comes from. So, anything that affects the cache, will affect the data in the DMVs. For example, DBCC...

Not seeing your structure, it's hard to know what the issue might be. I'd break it down. Take the query down to it's component parts & rebuild them, one step...

Microsoft has a bunch of monitoring built in to the Azure portal. It's not the easiest to use, and seeing all your instances at once is a real pain. However,...

There is no precise guidance. A table could be as little as one column or as many as the max, 1024. However, in general, you'll probably see no more than...

I missed the link in my last post. Here it is.

So, go to this Microsoft web page. Scroll down to the section titled "RDBMS scalability and performance". Look at stuff like, row mode memory grant feedback and others. A...

• This reply was modified 4 years, 8 months ago by Grant Fritchey. Reason: Missed the link

We are trying to help.

You said the rows were different. Do you mean the row estimates are different? That's different and could be an indication of the difference between enterprise...

So, "server name could not be resolved" could be that you simply have the connection string wrong. However, more often is the fact that the IP address that the service...

Yes.

Does this mean it needs only 3200 rows but is ending up reading 1700000 rows to...

We need to see the index definitions as well.  It seems to me that the index definitions would need to be different to produce plans and stats that drastically...

We need to see the index definitions as well.  It seems to me that the index definitions would need to be different to produce plans and stats that drastically...

If you could post the plans (note, please, not a picture of the plans, but the xml files), we might be able to provide insight. With just a description, I've...

I'd have to see the plans to understand what is happening. Compile variables, ANSI connection settings, these kinds of things can result in differences. There's no way to pick one...