Viewing 15 posts - 12,526 through 12,540 (of 22,224 total)
But, the first time you move a database onto a new server, there's nothing of that database in cache. At best you're looking at memory pressure that is exposed when...
"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 20, 2011 at 6:28 am
Craig Farrell (5/19/2011)
Steve Jones - SSC Editor (5/19/2011)
Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1Tried my humble best.
No, that was...
"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 19, 2011 at 1:38 pm
I didn't even know Hyperbac could be set to compress trace files. Cool!
By the way, rollover is supposed to give you a series of files, so that was working 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
May 19, 2011 at 6:49 am
Robert Pepin (5/18/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
May 19, 2011 at 6:47 am
I would not lay out the database by the transactions defined. Instead I would to set up standard database normalization, taking it out to 3rd normal form. It's a good...
"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 19, 2011 at 5:37 am
Why the restriction to not use a stored procedure? A stored procedure is just a wrapper on a query, and you're going to have to write a query no matter...
"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 19, 2011 at 5:35 am
One thing you don't have is rollover on the files enabled:
exec @rc = sp_trace_create @TraceID output, 0, @OutputFileName, @MaxFileSize, @EndTime
That should get changed to this:
exec @rc = sp_trace_create @TraceID output,...
"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 19, 2011 at 5:33 am
There is no gui from SQL Server. It's worse than that. If you launch from SSMS, you're going to have a brain dead version of PowerShell. Better to launch it...
"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 18, 2011 at 6:52 pm
Is this for data export? You don't have any kind of where clause at all. You're likely to see nothing but table scans from a query like that, and based...
"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 18, 2011 at 6:44 pm
Just remember that the Profiler gui is good for browsing the data later. Don't use it to monitor the server. Capture the data with a server-side trace.
If you really...
"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 18, 2011 at 6:36 pm
Two things, first, if you make a change to security, you might break the app. It doesn't sound like it's been terribly well designed. Inevitably these types of apps require...
"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 18, 2011 at 8:10 am
It could be that the trigger is the issue too. Can you just move the code into the stored procedure that does the insert?
"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 18, 2011 at 8:06 am
GilaMonster (5/18/2011)
Grant Fritchey (5/18/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
May 18, 2011 at 7:50 am
Lowell (5/18/2011)
you'd want...
"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 18, 2011 at 7:49 am
Ninja's_RGR'us (5/18/2011)
Grant Fritchey (5/18/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
May 18, 2011 at 6:20 am
Viewing 15 posts - 12,526 through 12,540 (of 22,224 total)