Viewing 15 posts - 5,971 through 5,985 (of 22,219 total)
One thing you don't mention in the article is whether or not the Columnstore index processed in row or batch mode. Just a guess, but it probably was in row...
"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 9, 2015 at 6:36 am
ericpap (6/8/2015)
SQLBill (6/8/2015)
"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 8, 2015 at 8:16 pm
In addition to the Stairway, always remember to reference the Books Online.
"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 8, 2015 at 3:48 pm
Steve Jones - SSC Editor (6/8/2015)
"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 8, 2015 at 3:29 pm
The log is just showing a start up. That's not really terribly helpful.
It sounds like someone restored a database, or possibly the VM as was suggested. The fact that your...
"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 8, 2015 at 12:47 pm
Not seeing your specific issues, it doesn't quite sound like a hardware issue. A series of DBCC commands must be coming from somewhere. That's not something that a failing disk...
"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 8, 2015 at 10:37 am
To determine connections, and just that, I'd probably use extended events. There's a login event that will tell you that. Now, understand, if people login to one database and then...
"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 8, 2015 at 7:07 am
Assuming we're talking about an identical database, indexes and statistics and exactly the same parameters being passed so that you can guarantee that you ought to be seeing identical execution...
"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 8, 2015 at 6:43 am
Assuming it's an active query, sys.dm_exec_requests has the database id right in the results. You could join that to sysdatabases to get the database name.
"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 8, 2015 at 6:40 am
mister.magoo (6/5/2015)
Jeff Moden (6/4/2015)
The more I see about XE, the less I like it.
Yes, that's why I'm trying to improve my experience 😀
Grant Fritchey (6/4/2015)
"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 5, 2015 at 1:51 pm
Jeff Moden (6/4/2015)
The more I see about XE, the less I like it.
Ha! The more I use it the more in love with it I get. What it can do...
"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 5, 2015 at 1:47 pm
There are small changes to Adventureworks within any given version of it, but they're not very radical. I use it for all the books I write. Many of the examples...
"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 5, 2015 at 1:44 pm
You can download a version of the 2008 database from codeplex that doesn't have filestream enabled. That will make things much easier.
"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 4, 2015 at 5:37 pm
I generally suggest outputting a file and querying that. It's still not fast, but you're going to generally be better off, especially in terms of the amount of information stored....
"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 4, 2015 at 5:34 pm
I just talked to Wendy Pastrick. They're not going to have one. There are tentative plans for one in March of next year.
"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 4, 2015 at 5:32 pm
Viewing 15 posts - 5,971 through 5,985 (of 22,219 total)