Viewing 15 posts - 76 through 90 (of 1,518 total)
GilaMonster (7/18/2012)
Cross apply to sys,dm_exec_sql_text
This won't work if the sproc has the "WITH RECOMPILE" option in its definition.
Running the following on such a proc gives me nothing:
SELECT deqs.creation_time, dest.text
FROM sys.dm_exec_query_stats...
__________________________________________________________________________________
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 8:37 am
andyansryan (9/19/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]
September 19, 2012 at 5:14 pm
GilaMonster (9/10/2012)
Marios Philippopoulos (9/10/2012)
Once I switch the db to single-user mode and take a log backup, there should be no active-log portion in any of the files.
There is always an...
__________________________________________________________________________________
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 12, 2012 at 6:09 am
GilaMonster (9/10/2012)
The rest sounds fine, just note that you won't necessarily be...
__________________________________________________________________________________
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 10, 2012 at 1:08 pm
GilaMonster (9/9/2012)
Perhaps. Depends just how many VLFs you're talking about.You've read Kimberly Tripp's blog post on transaction log throughput?
I have:
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
Running "dbcc loginfo" on the database gives me 3,155 records (VLFs).
I...
__________________________________________________________________________________
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 10, 2012 at 11:03 am
Fraggle-805517 (9/6/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]
September 9, 2012 at 7:33 am
GilaMonster (8/27/2012)
Let's put it this way, lots and lots of VLFs will slow the redo down.
Could the number of VLFs also be a contributing factor to poor mirroring performance, such...
__________________________________________________________________________________
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 9, 2012 at 7:22 am
Perry Whittle (9/5/2012)
Marios Philippopoulos (9/5/2012)
I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.Is that why it is not showing up?
So what path\filename did you...
__________________________________________________________________________________
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 6, 2012 at 10:08 am
Perry Whittle (9/4/2012)
Marios Philippopoulos (9/4/2012)
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'That location contains the log backups copied to the standby from the principal. There is no standby file there.
yes it...
__________________________________________________________________________________
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 5, 2012 at 2:46 am
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'
That location contains the log backups copied to the standby from the principal. There is no standby file there.
__________________________________________________________________________________
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 4, 2012 at 2:44 pm
Perry Whittle (9/4/2012)
Usually its set to the secondary destination directory which you can get from the following
exec sp_help_log_shipping_secondary_database 'yourdb'
Thanks, I tried that but did not see the information displayed in...
__________________________________________________________________________________
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 4, 2012 at 2:38 pm
SQL Kiwi (8/22/2012)
Marios Philippopoulos (9/11/2011)
Dropping the temp table explicitly at the end of a batch is considered good programming practice.
Certainly best practice for ad-hoc batches, but I would say it...
__________________________________________________________________________________
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]
August 23, 2012 at 5:57 pm
Wandrag (7/23/2012)
Thanks for this article!
I've changed some of our maintenance plans using SB.
Question: How can I limit ONLY the SB queries to use MaxDop=1?
I don't want to make this server...
__________________________________________________________________________________
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]
July 24, 2012 at 4:09 am
Could the slow restore rate be caused by high file fragmentation on the mirror server?
Perhaps we are due for a file defrag outage.
__________________________________________________________________________________
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]
July 21, 2012 at 9:40 pm
Robert Davis (7/18/2012)
No I meant stop/start the mirroring endpoints. Use an Alter Endpoint caommand and do it on both partners.
Thanks for clarifying, now I know what you mean; will try...
__________________________________________________________________________________
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]
July 18, 2012 at 8:56 pm
Viewing 15 posts - 76 through 90 (of 1,518 total)