Viewing 15 posts - 11,701 through 11,715 (of 22,219 total)
Do you mean every single action taken by the users for a week? You'll need to capture all events. I'd suggest looking up how to use extended events for that,...
"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
October 20, 2011 at 5:40 am
Just search Michelle's site a bit. You'll find this[/url].
"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
October 20, 2011 at 5:34 am
I've only seen one execution plan posted. It had a table scan, which means no cluster, and was predicated as follows:
[SFDReports].[Sales].[HOWLI_LOAD].[SQL_POST_DATE]>=N'2011-10-15 00:00:00.000' AND [SFDReports].[Sales].[HOWLI_LOAD].[SQL_POST_DATE]<=N'2011-10-19 00:00:00.000'
Based on what I'm seeing here,...
"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
October 20, 2011 at 5:32 am
You also have to take into account what happens with the transaction log. When you delete 1000 rows, they're recorded in the log that way, increasing the amount of information...
"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
October 20, 2011 at 5:24 am
Hyperbac is a file filter. It doesn't interfere in any way with the operation of SQL Server. Instead it gets between SQL Server and the file system and runs interference...
"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
October 20, 2011 at 5:21 am
What about building a drug name mapping table. You run through the data once, nightly, after a load, something, and map the names supplied to the drugs available into a...
"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
October 20, 2011 at 5:17 am
When you create a database you are required to create a transaction log as part of creating the database, so I don't think you're talking about that. The SQL Server...
"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
October 20, 2011 at 5:08 am
Sorry, I was slow getting back here. Gail's answering everything. Just out of curiosity, what is the cost threshold for parallelism on your server?
"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
October 19, 2011 at 12:11 pm
bkubicek (10/19/2011)
Grant Fritchey (10/19/2011)
If you’re a finalist we will need to confirm...
"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
October 19, 2011 at 7:07 am
By the way, DBA is just a term, we're talking data professionals concerned with databases. From the rules:
If you’re a finalist we will need to confirm that you work...
"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
October 19, 2011 at 6:37 am
Ooh, right, fill factor. Where's my head. Thanks Ninja!
"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
October 19, 2011 at 6:18 am
What are the 2nd & 3rd highest wait types. Unless you're sure that parallelism is actually a problem on your system (probably evidenced by CPU binding), this is not necessarily...
"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
October 19, 2011 at 6:15 am
That's an odd one. What version of SSMS are you running and what version of SQL Server is the server itself? You may need to update both.
"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
October 19, 2011 at 6:13 am
Also, you may want to assess which columns are defining the clustered index. If it's fragmenting that much, maybe you need a different cluster, possibly. Also, you need to evaluate...
"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
October 19, 2011 at 6:11 am
Pants got to eat, same as worms.
"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
October 18, 2011 at 1:42 pm
Viewing 15 posts - 11,701 through 11,715 (of 22,219 total)