Viewing 15 posts - 31 through 45 (of 1,517 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...
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...
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'.
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...
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...
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*...
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...
May 8, 2013 at 10:47 am
Perry Whittle (5/8/2013)
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...
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...
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...
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)
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...
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...
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!
March 17, 2013 at 8:40 am
Viewing 15 posts - 31 through 45 (of 1,517 total)