Viewing 15 posts - 12,796 through 12,810 (of 22,219 total)
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
There are a few situations where having your own mechanism for generating an identifier can make sense (distributed computing, stuff like that), but even then you'd probably b better off...
"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:26 am
Yes, you can capture the plans for user defined functions. You have to use extended events and with them you can capture the plan that is used for the UDF....
"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 6, 2011 at 6:25 pm
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 6, 2011 at 1:25 pm
mtassin (4/6/2011)
Grant Fritchey (4/6/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 6, 2011 at 8:25 am
Lynn Pettis (4/6/2011)
Brandie Tarvin (4/6/2011)
Grant Fritchey (4/5/2011)
Brandie Tarvin (4/5/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 6, 2011 at 8:20 am
Viewing 15 posts - 12,796 through 12,810 (of 22,219 total)