Viewing 15 posts - 7,081 through 7,095 (of 22,213 total)
Have you tried clicking on that link? It will open a graphical plan within SSMS.
But, if not, you can always query sys.dm_exec_text_query_plan. That will output just a raw varchar(max) column...
December 11, 2014 at 12:50 pm
That's news to me. I'm not a backupexec expert, but I've worked around it for years. We were able to have it run all sorts of things without automatically running...
December 11, 2014 at 9:28 am
Good gosh, don't do option 1. That will put additional stress on your production system, removing memory, fighting for CPU and disk access. No. Option 2 is pretty much the...
December 11, 2014 at 8:37 am
Yes. You're going to want to have that date value as a date. Otherwise, you'll have to parse that string and it will prevent index and statistics use leading to...
December 11, 2014 at 8:26 am
Glad to hear the solution. I was also going to suggest looking into bad parameter sniffing, but it's probably just the stats.
December 11, 2014 at 8:22 am
Don't do it.
Instead, give them permissions to create extended events[/url]. It's much more lightweight and much less fear of bringing down a production system.
December 11, 2014 at 8:20 am
No, I'm pretty sure that's a code issue. They're not cleanly disconnecting.
December 11, 2014 at 6:57 am
Run a query against sys.dm_os_wait_stats before and after running the query. It'll give you a pretty good idea what the query is waiting on.
Also, when you're running queries against sys.dm_exec_requests...
December 11, 2014 at 6:56 am
You need to check the condition of the server when you're getting the timeouts. Are there lots of connections, or only a few. Of those connections, are any blocked or...
December 10, 2014 at 8:58 pm
It depends on how your virtual environment is set up and managed. Many of them use physical storage, not virtual storage. In fact, a pretty hefty percentage are set up...
December 10, 2014 at 3:56 pm
Alvin Ramard (12/10/2014)
Koen Verbeeck (12/10/2014)
Grant Fritchey (12/10/2014)
December 10, 2014 at 3:54 pm
OK. That certainly makes more sense now. Yeah, I'd go with a derived table of some kind (doesn't have to be a CTE, but no reason not to) to get...
December 10, 2014 at 3:53 pm
Other than to allow for the use of the MAX field, why are you grouping this data anyway? From the example, you're running no other aggregations.
December 10, 2014 at 10:30 am
Without seeing the plans, I'm speculating. But, if the data sets are radically different between the two servers, that might explain it. If the cost threshold for parallelism is different....
December 10, 2014 at 10:24 am
JoshDBGuy (12/10/2014)
Grant Fritchey (12/10/2014)
December 10, 2014 at 10:21 am
Viewing 15 posts - 7,081 through 7,095 (of 22,213 total)