Viewing 15 posts - 12,751 through 12,765 (of 22,219 total)
This is just a SWAG, but do you have a system backup that runs that might be locking files? We ran into a similar issue when our system backup would...
"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
April 14, 2011 at 7:18 am
GilaMonster (4/14/2011)
Grant Fritchey (4/14/2011)
"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
April 14, 2011 at 6:20 am
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
"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
April 14, 2011 at 6:08 am
mohammed moinudheen (4/14/2011)
I have seen many job postings which requires people knowledgebale in...
"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
April 14, 2011 at 6:04 am
Nice article Craig. The company I left put up a SQL Superman job to try to replace me, despite my protests. My old boss just kept saying "Let's see what...
"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
April 14, 2011 at 6:01 am
GilaMonster (4/14/2011)
fname lname-1111520 (4/14/2011)
"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
April 14, 2011 at 5:58 am
Craig Farrell (4/13/2011)
Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of you, too?
There's...
"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
April 13, 2011 at 12:21 pm
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to turn 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
April 13, 2011 at 12:15 pm
ChrisM@home (4/13/2011)
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/2011)
"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
April 13, 2011 at 12:14 pm
Timothy Straub (4/13/2011)
Thanks for the info and yes I am testing the performance of a query. I was hoping to be able to test a separate DB...
"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
April 13, 2011 at 10:06 am
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
Hard one to answer. Unless there was 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
April 13, 2011 at 10:04 am
Stack overflow is pretty good too.
"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
April 13, 2011 at 9:12 am
It's going after the instance. Why would you do that?
I mean, for testing purposes, fine, but I wouldn't suggest running that in production.
"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
April 13, 2011 at 9:11 am
After the fact, when everything is done, without a trace file available? You can't. If you have a trace running, you can use that to get the user (assuming you're...
"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
April 13, 2011 at 9:10 am
Patrick_Fiedler (4/13/2011)
You can take the following statement:
selectcntr_value as [PageLifeExpectancyInSeconds]
fromsys.dm_os_performance_counters
whereobject_name like '%:Buffer Manager%'
and counter_name like 'Page life expectancy%'
If the value falls below...
"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
April 13, 2011 at 6:19 am
Viewing 15 posts - 12,751 through 12,765 (of 22,219 total)