Viewing 15 posts - 10,726 through 10,740 (of 22,224 total)
I just see this self-referencing foreign key
ALTER TABLE [dbo].[AT] WITH CHECK ADD CONSTRAINT [FK_AT_AT] FOREIGN KEY([AT_id])
REFERENCES [dbo].[AT] ([AT_id])
It joins the same table to itself.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 20, 2012 at 4:44 am
You can pull stuff straight out of the cache using dynamic management objects (DMO). The main couple that you're going to be interested in are sys.dm_exec_query_stats and sys.dm_exec_sql_text. Here's the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 20, 2012 at 4:39 am
matthew.peters (6/19/2012)
Thanks for the solutions, they're all great ideas, I'm looking to change the query structure first and see how that goes.
two questions
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 20, 2012 at 4:15 am
mvillegascuellar (6/19/2012)
Thanks guys for the quick response.These are queries not stored procedures.
Second I would like to capture both table hints and query hints.
Even with queries, they're stored in cache. You'll...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 7:13 pm
Nothing wrong with Olla scripts at all. I do thing Michelle Ufford's are also worth a look[/url]. They're simpler and easier to deal with I think.
You might also want to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 3:44 pm
Duplicate question. Please direct all answers to this post.
Please don't cross-post in the different discussion groups. Most of them are read by the same people. It just leads to confusion.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 3:38 pm
True. If the queries age out of cache you're in trouble. But, you'll get the most active queries immediately and you can capture more by rerunning the query against the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 3:16 pm
All the hints included in a query are stored with the execution plan, so you could query the plans, using XML, to pull the information out of the DMVs. There...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 3:07 pm
It's xml_deadlock_report event, which is the deadlock graph.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 11:08 am
Hmmm... A couple of points. I encrypted a proc and made a deadlock occur with it. I did get back the statement information as part of the XML deadlock graph...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 9:04 am
Oh, you're pulling it from the extended event data. That's great. Well done. Still, doesn't change things. I'm not sure how encryption affects it. I'm going to try to set...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 8:34 am
Ah, you know, I'm not sure. It might.
You're using traceflag 1222 to capture this?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 8:17 am
Try using the OBJECT_ID function with the database and object ID that are part of the input buffer. That should narrow it down.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 5:38 am
GilaMonster (6/19/2012)
Brandie Tarvin (6/19/2012)
"Surface"? Really?What kind of marketing department names a tablet with such a mundane moniker?
Surface was previously the name of their table computer (touch screen, about the size...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 5:35 am
george sibbald (6/19/2012)
based on all the tables being about that size, I agree with you, you'll be glad to hear.not my post btw 🙂
Ooops. Just saw the question. Didn't look...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 19, 2012 at 5:28 am
Viewing 15 posts - 10,726 through 10,740 (of 22,224 total)