Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Improve sql server logs

  I want to improve logs which stores in default trace by putting more efficient data according to se…

  farax_x

  1 replies

  10 years ago

  By: Gail Shaw

• setup alert for high cpu and high memory

  how can i set up alert for high cpu and high memory ?

  Almighty

  3 replies

  10 years ago

  By: Justin Manning SA

• Replicate SQL server database(PUBLISHER) to Always ON Availability Groups (Listener)(SUBSCRIBER)

  https://msdn.microsoft.com/en-us/library/hh710046.aspx I have configured replication between Always…

  nari.koud

  1 replies

  10 years ago

  By: nari.koud

• The media set has 2 media families but only 1 are provided.

  Hi All, it appears that I inadvertantly added a second file when creating a back up of a database t…

  Thom A

  1 replies

  10 years ago

  By: Gail Shaw

• Active-Active cluster + AlwaysOn HA

  Hi all, we currently have an active/active cluster and want to AlwaysOn HA in another data center. …

  GabyYYZ

  4 replies

  10 years ago

  By: GabyYYZ

• query needed

  I need to find the number of users hit on a database from last month ?

  ramyours2003

  3 replies

  10 years ago

  By: Gail Shaw

• Issue Cluster AlwaysON SQL 2014 SP1

  Hello, I have a issue on AlwaysOn Group two nodes (SQL 2014 SP1 - Windows 2012 R2 Datacenter). I ha…

  ERIC CRUDELI

  16 replies

  10 years ago

  By: Perry Whittle

• Service Account

  Hi, I have a couple of questions around best practices for SQL Server Service accounts 1>> Sh…

  Maverick100877

  6 replies

  10 years ago

  By: EdVassie

• T-SQL- find the simultaneously processing events

  This is a tricky one (for me anyways). Would appreciate any ideas on how to do this most effcientl…

  NJ-DBA

  5 replies

  10 years ago

  By: NJ-DBA

• Restore database with a different name on another server using NetApp-SnapProtect

  Guys, I'm looking for a solution to restore a database with a different name (on another SQL-server…

  gkramer 23701

  7 replies

  10 years ago

  By: Justin Manning SA

• Database Server Memory always showing 98%

  Hi, Production DB server is showing 98 percent always.How to bring it down. http://s392.photobucket…

  rameelster

  23 replies

  10 years ago

  By: Gail Shaw

• RAM to each Instance

  We are designing a new environment . 2 node cluster with 3 instance . 2 Instance in Node 1 and 1 in…

  David Rich

  3 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Index creation taking long

  In a test database server ,database changed to single user mode while creating non clustered index …

  rameelster

  5 replies

  10 years ago

  By: Jeff Moden

• how i can grant to the database

  hi , i can not grand to the database ,may i help me ? please

  benyaminprogramer

  2 replies

  10 years, 1 months ago

  By: Perry Whittle

• AAG failover to DR node

  Hi All, We have PROD and DR configuration with 1 primary 2 sec-replica. ON PROD DC we have Primary …

  vkundar

  2 replies

  10 years, 1 months ago

  By: vkundar