Forum Replies Created

Viewing 15 posts - 61 through 75 (of 1,341 total)

  • Reply To: Import/export

    Admingod wrote:

    I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and foreign key relationship how would be the export is...

    • This reply was modified 4 years, 2 months ago by  VastSQL.
  • Reply To: SQL Server data file distribution

    soumyarani0317 wrote:

    I am a newbie to SQL Server administration and config. Apologies if I appear to confuse/mix terminologies here.

    I am trying to find a way to take a snapshot...

  • Reply To: Always On Read-only routing

    Admingod wrote:

    I was working on with requirement to load balance the traffic coming from application to secondary SQL Server replicas in an Always on Availability group. Read-only routing refers to...

    • This reply was modified 4 years, 2 months ago by  VastSQL.
  • Reply To: Failover Clustering IP's

    Admingod wrote:

    Thanks! Sorry I wasn't clear, windows cluster is already configured. So I am looking to find how many more IP's is needed for install and configuring for SQL Server...

    • This reply was modified 4 years, 2 months ago by  VastSQL.
  • Reply To: Sudden PLE drop

    Grant Fritchey wrote:

    Mainly you need to look for what's using memory in such a way that the pages will be flushed. Again, if everything else is fine, this is probably just...

  • Reply To: Sudden PLE drop

    Jeff Moden wrote:

    VastSQL wrote:

    Grant Fritchey wrote:

    And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope....

  • Reply To: Sudden PLE drop

    Grant Fritchey wrote:

    And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No real...

  • Reply To: Sudden PLE drop

    Cebisa wrote:

    I would start by down loading Glenn Berry s diagnostic queries and running these.

    With page life expectancy, look at the long term trend. See Jonathan Kehayias blog about it...

  • Reply To: Database distribution in AlwaysOn

    as_1234 wrote:

    Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would...

  • Reply To: SELECT Statement BLocking

    Sergiy wrote:

    I cannot see how <blocking-process> stands on the way of <blocked-process>.

    Both queries apply shared locks, so, they should not block each other.

    Can you find what is waitresource in the...

  • Reply To: SELECT Statement BLocking

    Sergiy wrote:

    I cannot see how <blocking-process> stands on the way of <blocked-process>.

    Both queries apply shared locks, so, they should not block each other.

    Can you find what is waitresource in the...

  • Reply To: SELECT Statement BLocking

    Grant Fritchey wrote:

    Are they part of larger batches? There could be multiple statements involved.

     

    Yes Grant that what we found when ran the profiler trace many transaction with same spid but after...

    • This reply was modified 4 years, 4 months ago by  VastSQL.
  • Reply To: SELECT Statement BLocking

    Grant Fritchey wrote:

    You've identified some queries, but now you need to investigate their behavior within the system. The way to do this is to look at the execution plan in order...

  • Reply To: Upgrading from 2014 to 2019 without Downtime

    jcarranza 23978 wrote:

    Can you explain "We have 3 node in which 2 are SQL Cluster and 3rd one is Always On AG".?

    But let's assume  you have a 3 node AwalysON AG,...

  • Reply To: Migrating 2017 to 2019 with AGs

    can you try creating two server with SQL 2019 in same windows cluster add them to AOAG. Create replicas in new servers and failover to SQL 2019 and then remove...

Viewing 15 posts - 61 through 75 (of 1,341 total)