Forum Replies Created
Viewing 15 posts - 14,191 through 14,205 (of 22,219 total)
-
RE: How to: Check which query causing the most cpu usage?
Exactly what Gail says. You can use the list she provided earlier as the basis for your server side trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to: Check which query causing the most cpu usage?
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?Yes, I know there are many queries or sysyem sp's that cannot be used...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL SERVER Training on Advanced database administration
Then all you've got to do is run a search through Google or Bing. Here's one. First thing listed is, again, Microsoft training. Going to the source never hurts.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to: Check which query causing the most cpu usage?
tt-615680 (10/5/2010)
GilaMonster (9/29/2010)
arr.nagaraj (9/29/2010)
Default trace contains the recently ran queries along with a few useful informationlike CPU, starttime etc. .. Probably can help your root cause analysis
The default trace does...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL SERVER Training on Advanced database administration
I don't know that there's any one place to get advanced training online (meaning for free). But there are several places you can go. Microsoft has a number of courses...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: 40 vs. 45 Hour Workweeks
I carve time out of my day, at work, to make sure I'm learning stuff. I read a bit, test a bit, write a bit, at work, so that I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: New User, just wanted to say hi
Welcome to the party. Keep your hands and feet inside the vehicle at all times.
Yeah, the ability to run a search engine should probably be one of the most introductory...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Index tuning advisor errors. cannot find stored procedure
I'm still of the opinion that you are either not connecting to the correct database, or your security doesn't allow you to see those procs. It's also possible that they're...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?Doesn't really matter does it?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: GUID clustered indexes vs. RID
Rob Schripsema (10/4/2010)
(Just posted a similar comment on Glen Berry's blog at http://www.sqlservercentral.com/blogs/glennberry/archive/2010/3/22/why-uniqueidentifier-is-a-bad-choice-for-a-clustered-index-in-sql-server.aspx. This is not meant as a double post, just not sure if responses to older blog articles..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Performance monitoring strategies?
Until you get into the third party tools (my favorites, in no particular order, are Red Gate SQL Response, Confio Ignite, Idera Diagnostic Manager), then I'd suggest a combination of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Most costly queries
You might be looking for the DMO sys.dm_exec_query_stats. It contains an aggregation of the performance of the queries currently in cache. You can also look at sys.dm_exec_proc_stats in 2008.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Optimization best practices
I'm assuming you're not talking about disaster recovery (DR)?
Just for tuning performance, first thing I'd do is set up data collection to get a good set of metrics from performance...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Women and Men - Same or Different?
Matt Miller (#4) (10/4/2010)
Steve Jones - Editor (10/4/2010)
david_wendelken (10/4/2010)
...So, rather than piss and moan about not getting equal pay for equal work, why not learn what career and job negotiating...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 14,191 through 14,205 (of 22,219 total)