Viewing 15 posts - 12,796 through 12,810 (of 22,224 total)
CANCER (4/8/2011)
This is what i am getting when i try to collect execution plan.
The query has exceeded the maximum number of result sets that can be displayed in the 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
April 11, 2011 at 4:56 am
No short answers here. Are you sure it's memory that's the issue. Have you looked at wait states on the server? What are things waiting on? Have you gathered metrics...
"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 8, 2011 at 6:10 am
Just so you know, certification is unlikely to help you get hired or get started in a DBA job. In general, you're better off working your way in to 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 8, 2011 at 6:09 am
CANCER (4/7/2011)
thanks for your reply
yes the db is in full recovery and log backups job is running succesfully for every hour.
we have clustered and non-clustered indexes on tables and there...
"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 7, 2011 at 6:24 pm
Well, the optimizer isn't dumb, so it makes me wonder if something in your code is causing the problem. That's usually the issue.
"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 7, 2011 at 11:05 am
Sounds like you have a couple of separate issues.
On the log, is your database in Full recovery? If so, are you running log backups? If your database is 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 7, 2011 at 11:03 am
Rather than going to dynamic SQL, have you looked into using SSIS. It's a great ETL tool and you can automate it's behavior, it'll work with referential constraints, there are...
"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 7, 2011 at 10:59 am
It depends on the SAN and the software used there. There are transaction aware softwares used on some SAN systems that can copy the database from one location to another,...
"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 7, 2011 at 10:56 am
After the upgrade did you manually update all the statistics? If not, those are slowly being recreated and you should see better performance eventually. If you did that, then it'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 7, 2011 at 10:52 am
If you have two completely different plans in cache, it's probably the connection settings, specifically the ANSI settings, that are different between Management Studio and the application. Focus there.
"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 7, 2011 at 10:37 am
Brandie Tarvin (4/7/2011)
Turning attention to a different media... Anyone remember Captain Carrot and the Zoo Crew?
Nope. Never heard of that one.
"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 7, 2011 at 8:27 am
TheSQLGuru (4/7/2011)
sqldba_icon (4/6/2011)
Grant Fritchey (4/5/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 7, 2011 at 7:28 am
I agree with everyone, but just want to add an additional caution about GUIDs. They really can be problematic, so be sure, really sure, you need them before you implement...
"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 7, 2011 at 6:32 am
You really need to take a transaction log backup. It sounds like NetApp isn't doing the job. I'd get on it immediately. The only proper way to resolve the full...
"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 7, 2011 at 6:23 am
Even if you get a faster drive, you're going to realize the most improvement by moving stuff to separate drives. Even with SSD or something else, you will experience queuing...
"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 7, 2011 at 5:31 am
Viewing 15 posts - 12,796 through 12,810 (of 22,224 total)