Viewing 15 posts - 9,316 through 9,330 (of 22,224 total)
This is usually caused from one of two sources. You've had data changes recently that have resulted in the distribution of your data to change, updating the statistics, and the...
"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
December 9, 2013 at 12:31 pm
When I'm deploying database changes to an Enterprise system, I'll use snapshots to make rollbacks very fast and easy should something go wrong during the deployments. I won't keep those...
"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
December 9, 2013 at 7:56 am
It sounds like you are running into some sort of resource issue according to the error message:
Insufficient system resources exist to complete the requested service
Without more information, I'm not sure...
"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
December 9, 2013 at 7:52 am
The same process will write dirty pages to disk and free clean pages when they pass the least recently used threshold.
"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
December 9, 2013 at 7:50 am
Ed Wagner (12/6/2013)
Grant Fritchey (12/6/2013)
Oh well heck, everyone else has said it and now I feel left out.Congrats Gail.
What was it you did again?
...
Kidding, kidding. Put that stick down... 😛
Yeah...I...
"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
December 6, 2013 at 6:49 am
kevaburg (12/6/2013)
Grant Fritchey (12/6/2013)
kevaburg (12/6/2013)
"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
December 6, 2013 at 6:22 am
But you were right to point out that what I said was insufficiently clear. That can lead to all sorts of problems.
"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
December 6, 2013 at 6:20 am
Oh well heck, everyone else has said it and now I feel left out.
Congrats Gail.
What was it you did again?
...
Kidding, kidding. Put that stick down... 😛
"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
December 6, 2013 at 6:18 am
kevaburg (12/6/2013)
Grant Fritchey (12/2/2013)
"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
December 6, 2013 at 6:14 am
kevaburg (12/6/2013)
For this sort of thing I would recommend a server-side profiler trace. Don't use the Profiler itself if you intend to trace over an extended period.
If you're on...
"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
December 6, 2013 at 6:12 am
Where's Red Gate Press?
I've got several of their books on my desktop and not just because I work/write for them.
"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
December 4, 2013 at 11:06 am
Wonderfully excellent advice already posted here. I'll add one more. Check out Jason Strate's Monthly DBA Checklist[/url]. It's a pretty good starting point for ensuring you have the basics 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
December 4, 2013 at 7:01 am
As much as possible, always go to the documentation in Books Online first.
Here are the requirements for Memory Optimized Tables. It's 64 bit and Enterprise only (or Development, yes).
As...
"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
December 4, 2013 at 6:57 am
Go into SQL Server Management Studio and change the security settings for that login so that it can't access the other database. Here's an introduction to security in 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
December 4, 2013 at 6:53 am
I'd suggest taking a look at sys.dm_exec_requests to see what the process is waiting on. You'll at least understand where the bottleneck lies.
"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
December 4, 2013 at 6:49 am
Viewing 15 posts - 9,316 through 9,330 (of 22,224 total)