Viewing 15 posts - 6,316 through 6,330 (of 22,226 total)
What you're doing, the file utilization. Although, that's the size of the files, not the size of the data. A simple way to get a view of this is to...
"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, 2015 at 4:55 pm
Extended events filter at the point of capture. That means they radically reduce their footprint as they will only capture the events you're interested in. Trace captures every event first,...
"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, 2015 at 4:36 pm
Mind you, tracking backup size is important too, but for managing the backups and their drives, not for maintaining the database size tracking.
"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, 2015 at 12:49 pm
Fair warning, filtering in trace occurs after the trace event is captured. Filtering only really helps with the data you're storing from the capture. Extended events work much better.
"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, 2015 at 12:20 pm
I wouldn't use the backups to estimate database size. Instead I'd monitor the size and growth the database itself.
"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, 2015 at 12:19 pm
Show what you've done so far. The T-SQL syntax you're looking for is JOIN.
"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, 2015 at 11:13 am
You really shouldn't have anything in a trial environment that you're not ready to throw away. After all, the tests could have just failed.
But as others have said, export/import is...
"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, 2015 at 11:08 am
Steve Jones - SSC Editor (4/14/2015)
Ed Wagner (4/14/2015)
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.
Well done, Grant. I'd say you've earned a victory beer, so enjoy...
"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, 2015 at 10:51 am
And this makes 14,001 posts. My fingers are tired.
"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, 2015 at 8:43 am
It's not in the system_health extended events session. I know that.
"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, 2015 at 8:41 am
xsevensinzx (4/14/2015)
Grant Fritchey (4/14/2015)
"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, 2015 at 8:29 am
t.pinder (4/14/2015)
Grant Fritchey (4/14/2015)
"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, 2015 at 6:52 am
Yeah, it's all largely still applicable. Having more than one disk helps I/O. Further, having more than one file/filegroup helps too. You do have to take into account the number...
"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, 2015 at 6:07 am
Ville-Pekka Vahteala (4/14/2015)
Grant Fritchey (4/14/2015)
OK. Fair enough. Let's try this one. It might also be found somewhere in here... maybe.
These did not have those numbers what I asked, but they...
"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, 2015 at 6:02 am
GilaMonster (4/14/2015)
Grant Fritchey (4/14/2015)
You could try searching sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text to find DELETE/TRUNCATE statements.Truncate doesn't get cached iirc, because it's a DDL statement
Ah, true. Hadn't thought that...
"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, 2015 at 6:01 am
Viewing 15 posts - 6,316 through 6,330 (of 22,226 total)