Viewing 15 posts - 9,931 through 9,945 (of 22,213 total)
It will help some. Who does the maintenance on your SQL Server instance? If no one, you probably need to get that set up. That'll give you a lot more...
March 23, 2013 at 4:25 am
I don't quite get how those numbers are laying out. Sorry.
You have max degree of parallelism set to 0, 1024, 0, 0? It's just a single value.
March 22, 2013 at 11:30 am
Sorry, I can't tell anything from that. You can export an execution plan as a .SQLPLAN file and then load it up to the web site. Then I can see...
March 22, 2013 at 11:22 am
That's roughly the opposite of what you ought to see. Can you get both actual execution plans and post them so we can see what the optimizer is doing?
March 22, 2013 at 9:16 am
Nope. That sounds pretty abnormal. I'd be concerned that there was something wrong with the server or the SQL Server instance. Check the configuration to ensure that you have memory...
March 22, 2013 at 9:14 am
chandan_jha18 (3/22/2013)
As a side note, can you please let me know how to find the tables actually involved in the execution plan so that I can filter the unused ones....
March 22, 2013 at 8:56 am
First thing, looking at the SELECT operator in your execution plan, you have a timeout. This means that the optimizer gave up on attempting to find a good enough plan...
March 22, 2013 at 6:53 am
You won't be able to show that kind of a time period unless you first set up mechanism for capturing the metrics over time in order to aggregate it. Otherwise,...
March 22, 2013 at 6:39 am
I'd have to test it to be sure, but you might be able to create an index with LastName as the leading edge and the other columns as part of...
March 22, 2013 at 6:22 am
Since this is a post to a 2008 forum, you should know that you're already capturing deadlock information in the system_health extended events session that is running on your servers,...
March 22, 2013 at 4:32 am
Multiple instances will absolutely affect performance, yes. You just need to monitor your systems to understand how much they will affect it.
March 22, 2013 at 4:29 am
winmansoft (3/19/2013)
when the rows will be added to tempdb(update statement, select statement) and when it is cleared ?
Read the documentation supplied by Microsoft. They lay it out there. In the...
March 20, 2013 at 4:47 am
Sound a lot like interview questions, but since this is hours on...
The cache is where the query plans that have been compiled by the query optimizer are stored in order...
March 19, 2013 at 11:26 am
bugg (3/19/2013)
Grant Fritchey (3/19/2013)
March 19, 2013 at 5:03 am
The checkpoint process is what writes all the dirty pages to disk.This is usually a fairly quick event. If it's hanging and running for a really long time, I guess...
March 19, 2013 at 3:38 am
Viewing 15 posts - 9,931 through 9,945 (of 22,213 total)