Viewing 15 posts - 61 through 75 (of 1,518 total)
Perry Whittle (10/18/2012)
glad you got it resolved, DBCC LOGINFO is your friend here 😉
It's a useful command indeed.
However, it is not really needed here.
All you have to do is...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 18, 2012 at 7:52 am
As I expected, I had trouble dropping one of the "extra" log files because it was in use:
alter database [DB1] REMOVE FILE LOG_3;
However, after taking a log backup I was...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 18, 2012 at 3:30 am
L' Eomot Inversé (10/16/2012)
Marios Philippopoulos (10/16/2012)
How do I know how many records are enough and how many GB I need to insert to cause a file rollover?
There are various ways...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2012 at 1:44 pm
Perry Whittle (10/16/2012)
Marios Philippopoulos (10/16/2012)
I will probably not do that, as it seems a bit too much voodoo to me... 🙂
Whats voodoo about creating a table, inserting some records...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2012 at 10:19 am
Perry Whittle (10/16/2012)
that is correct, did you perform the create, insert, truncate that Gail advised
I will probably not do that, as it seems a bit too much voodoo to me......
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2012 at 8:15 am
To find out which log files are currently in use:
DBCC LOGINFO ('DBNAME');
Output records with status=2 signify which log file is currently in use.
Multiple log files and why they're bad:
http://sqlskills.com/blogs/paul/default.aspx#p1
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2012 at 4:28 am
Artoo22 (10/15/2012)
And Paul Randal's Shrink Alternative:
So what if you *do* need to run a shrink? For instance, if you've deleted a large proportion...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2012 at 4:22 am
GilaMonster (10/13/2012)
Very normal with LOBs, they do take huge amounts of time to move around. You just have to wait.
Thanks for the advice. 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 13, 2012 at 2:44 pm
I found out that this data file contains data from a text column.
Could this be the reason I am having trouble shrinking the file?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 13, 2012 at 11:36 am
GilaMonster (10/13/2012)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 13, 2012 at 11:35 am
I use the "Disk Usage" report in SSMS to get total size and used space.
I found the reason.
This filegroup is used for a TEXT column in a table that itself...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 13, 2012 at 9:51 am
I got it to work, but I am puzzled why... 🙂
I ran the following to disable AlwaysOn:
Disable-SqlAlwaysOn -ServerInstance "SERVER1\INSTANCE1" -force
This caused a service restart this time.
Then reran this to...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 4, 2012 at 12:12 pm
In addition to what has already been posted: include the partition_number column, output from the sys.dm_db_index_physical_stats DMV, in the list of columns you consider in your analysis.
If your database is...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 29, 2012 at 2:09 pm
Eric Mamet (9/17/2012)
I was just wondering about SQL Server Performance monitoring tools but we are a very small shop, hence free would be much better!
Since two years passed...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 29, 2012 at 9:59 am
GilaMonster (9/27/2012)
p.s. You don't need a LIKE match for the procedure name....
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 27, 2012 at 1:50 pm
Viewing 15 posts - 61 through 75 (of 1,518 total)