SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• QUERY STORE: how can i query it?

  If Query Store is running in our production server, particular database, is there a way I can query…

  VoldemarG

  1 replies

  5 years, 9 months ago

  By: Sue_H

• Instance level trigger to store login information (who created what)

  Hello SSC, I am looking for a simplified way to track which user created which login, Surprisingly …

  Lord Slaagh

  6 replies

  5 years, 10 months ago

  By: Steve Jones - SSC Editor

• Running generic query for table information

  Hi, I want to run the below query to get information about the tables and columns for better unders…

  sizal0234

  7 replies

  5 years, 10 months ago

  By: ScottPletcher

• Parameter Sniffing

  Hi All, I know there are various causes for parameter sniffing issues, but one I want to focus on i…

  Mike Scalise

  9 replies

  5 years, 10 months ago

  By: Mike Scalise

• FILEGROUP ... CONTAINS MEMORY_OPTIMIZED_DATA' failed because it is not supported

  Hi all, I have: Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul 5 2017 23:4…

  89netanel

  3 replies

  5 years, 10 months ago

  By: MVDBA (Mike Vessey)

• Txn log file is full. Error 9002

  Hi All, Here is the scenario on of the test servers. The transaction log is full. The database is i…

  bobrooney.81

  6 replies

  5 years, 10 months ago

  By: Thomas Rushton

• Script to help check performance and bottle necks

  Hello SSC and Happy Friday! I am looking for an "all in one" script that can help me identify bottl…

  Lord Slaagh

  2 replies

  5 years, 10 months ago

  By: Lord Slaagh

• TDE for Always on databases

  Hi All, In terms configuring and usage of TDE encryption is there a difference for Standalone insta…

  bobrooney.81

  1 replies

  5 years, 10 months ago

  By: Eddie Wuerch

• High CPU usage

  Hi All , I need to troubleshoot high CPU usage in a dedicated SQL server (>90%) . Please advice …

  WhiteLotus

  9 replies

  5 years, 10 months ago

  By: Jeff Moden

• Failed Data collection / MDW

  Hi All, Our data collection has been enabled for a while but when I tried to view the query statist…

  WhiteLotus

  3 replies

  5 years, 10 months ago

  By: WhiteLotus

• script out the dbmail settings and profiles

  How can we take the script of existing db mail  settings and profiles  ?

  ramyours2003

  2 replies

  5 years, 10 months ago

  By: Phil Parkin

• Performance Issue

  We are experiencing memory issue in one of the server  where we observed LATCH_EX is being caused b…

  ramyours2003

  2 replies

  5 years, 10 months ago

  By: Grant Fritchey

• Looking for recommendation on "cost threshold value"

  H All, What is the recommended value for setting sp_configure setting "Cost Threshold For Paralleli…

  vsamantha35

  5 replies

  5 years, 10 months ago

  By: Guy Bishop

• SQL AG Secondary Database Backup Throwing "not supported" error with COPY_ONLY

  Hello. I am using SQL Server 2016 with 2 Node AG.  There is no listener. On the Secondary node when…

  ganci.mark

  12 replies

  5 years, 10 months ago

  By: Beatrix Kiddo

• Replication CDC -- Cannot Truncate Table

  Dear All, We just enabled Replication services (CDC) on few of the databases. Now we realize tables…

  GonnaCatchIT

  4 replies

  5 years, 10 months ago

  By: MVDBA (Mike Vessey)