Forum Replies Created

Viewing 15 posts - 1 through 15 (of 1,272 total)

  • 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 1 month, 3 weeks 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...

  • Reply To: Avamar Backup--Is it good?

    Grant Fritchey wrote:

    VastSQL wrote:

    Thanks Grant .. Can you suggest any tool to reduce the RTO?

    The exact reason is the BC team want to reduce the RTO from 100 minutes we mentioned...

  • Reply To: Avamar Backup--Is it good?

    sterling3721 wrote:

    Used Symantec / Backup Exec, then switched to Avamar Backup. But I only use native backup on sql server side; once the backup is done, backup team can back...

  • Reply To: Avamar Backup--Is it good?

    Grant Fritchey wrote:

    I'm not aware of this tool, so no real comment on it one way or the other.

    However, the rules for any 3rd party solution for backups are very simple....

  • Reply To: Avamar Backup--Is it good?

    anthony.green wrote:

    Never heard of it but from a quick google it seems its another DELL EMC product.

    We did have Data Domain at one place I worked another DELL EMC product...

  • Reply To: Software to send Report

    Jeff Moden wrote:

    VastSQL wrote:

    Hi Experts,

    Currently we are using SQL Server and Database Mail to send reports and with new projects and requirements it seems like the Report sending will increase ....

    • This reply was modified 8 months ago by  VastSQL.
  • Reply To: Software to send Report

    MVDBA (Mike Vessey) wrote:

    SSRS is fairly solid for this

    you can subscribe to reports (and get them emailed to you) and keep historic versions on the server... plus you can export in excel,...

  • Reply To: Software to send Report

    anthony.green wrote:

    It all depends what's required.

    SSRS

    PowerBI

    Tableau

    Qlik

    All of these are data visualisation/reporting tools.

    But it depends what's needed, just a simple dump of data, send mail is a crude way but hey...

  • Reply To: Archive CLOB data

    frederico_fonseca wrote:

    so you are telling us that doing a

    insert into archive_table
    select *

    from main_table where filtering_column = date_to_archive 

    takes 5 minutes?

    or that it takes that amount of time retrieving...

  • Reply To: Restore Gene : Automating SQL Server Database Restores

    Thanks Paul for the wonderful script.

    I have a requirement where the Primary and Secondary are in totally different domain. Now I am moving files through FTP. Can you help me...

Viewing 15 posts - 1 through 15 (of 1,272 total)