Viewing 15 posts - 31 through 45 (of 1,518 total)
Thank you for this article.
I knew about parameter sniffing, but not about memory sniffing and the tempdb aspect of it.
Good to know...
__________________________________________________________________________________
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 15, 2013 at 9:11 am
Lowell (7/5/2013)
you missed Sean's snippet where you have to use a DAC(Dedicated Admin Connection) in order to see the statsblob; if you do that, the dmv sys.sysobvalues would be accessible.
Ah...
__________________________________________________________________________________
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 5, 2013 at 10:40 am
I'm getting this error when running the above script (on both SQL 2008 and SQL 2012):
Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.sysobjvalues'.
__________________________________________________________________________________
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 5, 2013 at 8:58 am
Sean Pearce (7/5/2013)
Stats are stored in a binary large object called a statsblob. These are very small, even with very large tables, and you will not find any performance gains...
__________________________________________________________________________________
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 5, 2013 at 8:53 am
Hey all, thanks for the feedback.
I ended up opening a case with Microsoft, asking them about the requirement for different instance names. After some back and forth, Microsoft has confirmed...
__________________________________________________________________________________
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]
May 25, 2013 at 6:22 am
Perry Whittle (5/9/2013)
Marios PhilippopoulosAlso in Windows Server 2008 and above, it is not the cluster *service*...
__________________________________________________________________________________
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]
May 9, 2013 at 5:35 am
fb.cs99 (5/8/2013)
@SSCommitted Did all of your database servers have to be upgraded to 2012 in order for your configuration to work?
Yes.
Also all database servers need to be in a...
__________________________________________________________________________________
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]
May 8, 2013 at 10:47 am
Perry Whittle (5/8/2013)
__________________________________________________________________________________
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]
May 8, 2013 at 9:50 am
AlwaysOn Avail Groups is a great feature, but I am looking forward to a day when it will be possible to sync logins, linked servers, operators, jobs, sp_configure settings and...
__________________________________________________________________________________
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]
May 8, 2013 at 8:55 am
We have implemented AlwaysOn Availability Groups (AG) on a 3-node cluster, consisting of 2 subnets: primary and DR.
2 nodes on the primary site host a failover-cluster instance (FCI) in 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]
May 8, 2013 at 8:43 am
We are using a DNS alias for the virtual network name (VNN) of the sql instance on the FCI cluster to direct connectivity of our applications to the prod instance.
Say...
__________________________________________________________________________________
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]
March 29, 2013 at 9:51 pm
Perry Whittle (3/29/2013)
Marios Philippopoulos (3/26/2013)
Thank you for the article.
You're welcome.
Marios Philippopoulos (3/26/2013)
__________________________________________________________________________________
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]
March 29, 2013 at 9:24 pm
Perry Whittle (3/27/2013)
Marios Philippopoulos (3/26/2013)
I was reading an article that described a similar scenario of a single WSFC comprised of 2 FCIsCould you provide the article link please
Here 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]
March 27, 2013 at 3:31 am
Thank you for the article.
I have a question about the instance names: do they *have* to be different? If anything, for DR purposes, they instance names should ideally be the...
__________________________________________________________________________________
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]
March 26, 2013 at 7:17 pm
I really liked the lookup-table technique for deleting data from a clustered index.
Will definitely suggest that to our dev teams going forward.
Thank you for the article!
__________________________________________________________________________________
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]
March 17, 2013 at 8:40 am
Viewing 15 posts - 31 through 45 (of 1,518 total)