SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• migration

  Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If yes, what ar…

  sqlguru

  3 replies

  2 hours, 52 minutes ago

  By: Grant Fritchey

• SSAS connection failures. Unable to read data from transport connection.

  Hi, Standalone default SSAS is installed. No issues connecting from SSMS on the server where SSAS i…

  ramana3327

  2 replies

  1 day ago

  By: trupti

• Blocking by select against sys.dm_db_index_physical_stats

  We recently upgraded from 2014 to 2017 (Enterpise Edition, CU 15) and since the upgrade we've seen …

  Josh B

  5 replies

  2 days, 23 hours ago

  By: Jeff Moden

• SQL Server has encountered [x] occurrence(s) of I/O requests taking longer

  Hi, We have this error from time to time, not all the time but when it does SQL is reporting as hig…

  lanky_doodle

  5 replies

  3 days, 23 hours ago

  By: Michael L John

• cannot grant user view definition on a database

  I have a number of databases on a sql server 2017 instance. For most databases i have been able to …

  winston Smith

  2 replies

  5 days, 2 hours ago

  By: Johan Bijnens

• Troubles with in memory OLTP performance degradation

  I started with a new company recently and they use in memory OLTP which is something I haven't used…

  tommiwan

  8 replies

  1 week, 5 days ago

  By: Jeff Moden

• Always on AG

  I have availability group configured with multiple secondary replica's. Looking to additional secon…

  sqlguru

  4 replies

  2 weeks, 4 days ago

  By: Jeffrey Williams

• Does the db_ddladmin database role permissions apply to db system object?

  The db_ddladmin is another powerful role because it allows a user to create, drop, or modify any ob…

  HookSQLDBA7

  4 replies

  1 month ago

  By: durai nagarajan

• SQL Server database monitoring tool.

  Hi Expertise, Kindly suggest  SQL Server database Centralize monitoring tools with historical repo…

  SQL Galaxy

  3 replies

  1 month ago

  By: andreas.kreuzberg

• two log reader agents in the same publisher

  Hello , I have a transactional replication that synchronizes to two different subscribers subscribe…

  abdalah.mehdoini

  1 replies

  1 month, 1 week ago

  By: Ant-Green

• Installation error

  SQL Installation is got failed  with error  1603  and no sql  is installed  previously .How to…

  ramyours2003

  2 replies

  1 month, 1 week ago

  By: EdVassie

• Why are the logical reads appearing in IO STATISTICS even after cleaning Cache

  Hello, I am trying to understand the output of IO STATISTICS . I run some queries like as bellow : …

  MrRobot

  2 replies

  1 month, 1 week ago

  By: Jeff Moden

• Table has no data but query takes 20 secs to complete

  Hi All, I have come across one issue today and I am looking for some suggestions. select @@version …

  vsamantha35

  19 replies

  1 month, 3 weeks ago

  By: vsamantha35

• Query with query ID (nnn) is not found in the query store

  Hi: I ran into an issue when I looked to try to manually force a plan from SYS.DM_DB_Tuning_recomme…

  MMartin1

  1 replies

  1 month, 4 weeks ago

  By: MMartin1

• Restore data for a single tenant in a multi tenant DB

  Our OLTP is being converted from a one tenant per database structure to a multi tenant DB. It was e…

  askcoffman

  4 replies

  2 months ago

  By: askcoffman