Viewing 15 posts - 8,206 through 8,220 (of 22,226 total)
Yeah, it's going to try to backup SQL Server files in that case.
"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
May 12, 2014 at 4:45 am
I don't know the Windows tools you're referencing and couldn't offer a suggestion there. I would assume you could, but I don't know.
"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
May 12, 2014 at 3:51 am
Whether or not you clear the buffers or the cache before you measure performance really comes down to what you're trying to measure. I agree with Kevin that most queries,...
"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
May 12, 2014 at 3:38 am
Most of the time, this is caused by the drive being full. You can even see information from Microsoft on this. There is a race condition in 2005 that can...
"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
May 12, 2014 at 3:29 am
How do you mean the user is going to generate things automatically? Do you mean when writing T-SQL it will automatically figure out the relationships? Nothing does that automatically within...
"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
May 12, 2014 at 3:20 am
SQL Server will take all the memory on a system that you let it take and it will hold on to that memory pretty much indefinitely. It's not a problem....
"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
May 10, 2014 at 8:20 am
The pages on the disk are fundamentally the same, heap or index. It's what gets stored on those pages and how one page is related to another that is different....
"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
May 10, 2014 at 8:10 am
The query against sys.dm_exec_requests will show all the queries running as well as any blocking. You can see the resources being used, how long a query has been running, pretty...
"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
May 9, 2014 at 12:29 pm
Not enough information to really say for sure what it might be, but since restarting changed the behavior, I'm thinking one of two things. First, it's possibly you had resource...
"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
May 9, 2014 at 12:04 pm
william.rees.howells (5/9/2014)
Please forgive my stupidity 🙂
Nothing to forgive. So far, I'm the only one who posted anything stupid on this thread.
"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
May 9, 2014 at 10:59 am
Yeah, what Gail said. It'll be live on Tuesday.
"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
May 9, 2014 at 10:31 am
william.rees.howells (5/9/2014)
Belarc Advisor. It's more for auditing but it shows your license keys as well. Seemed to do the trick and it was lucky because it was the first...
"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
May 9, 2014 at 9:03 am
Which key finder did you use? I tried one and it didn't work. The first PowerShell script I tried also didn't 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
May 9, 2014 at 7:46 am
Grant Fritchey (5/9/2014)
"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
May 9, 2014 at 7:21 am
I'm attempting to run the executable now and I keep getting an error about "Invalid license data." I've got emails sent to Microsoft to see what's up with 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
May 9, 2014 at 7:19 am
Viewing 15 posts - 8,206 through 8,220 (of 22,226 total)