version store

SQLServerCentral Article

TempDB growth due to version store on AlwaysOn secondary server

  • Article

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.

4.84 (19)

You rated this post out of 5. Change rating

2016-11-07

10,168 reads

Technical Article

Integration with active directory

  • Topic

hello all,I tried to integrate Sql server 2000 instance in the AC and came up with this message " sql server enterprise manager could not add server to the  AC",(stored procedure sp_activedirectory_scp failed to to access registry key)Can anyone help out? pleaseAkan   

You rated this post out of 5. Change rating

2004-11-14

Blogs

T-SQL Tuesday #176 One piece of advice that you wish Past you had

By

This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...

T-SQL Tuesday #176: One piece of advice for Past Steve

By

I almost missed this month, so this is also a good #SQLNewBlogger post. I...

Deleting Old Local Git Branches–#SQLNewBlogger

By

I had a lot of local branches for a repo (actually a few repos)....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers