According to few links from online search looks we can use dbi: sybase to connect to Microsoft SQL Server from Linux server

https://www.perlmonks.org/index.pl?node_id=669089

https://metacpan.org/pod/DBD::Sybase

Thank you.

Not after the Index maintenance job. I check the queries that are consuming for years. They are not new o nes. I tried  updating the stats & cleared the...

• This reply was modified 1 year, 2 months ago by  ramana3327.

Thanks.

Is it better to suspend the mirroring when mirror server is not reachable for long period of time or leave as it is?

Data always commit on Principle first with asynchronous mode.

Why data will be lost with pausing mirroring?

We don’t have any database maintenance jobs (Index/stats) scheduled during that time period.

Thanks Jeff. According to the link performance regression happens with LEGACY_CARDINALITY ESTIMATION, when changed the database comparability level from old version(100) to native/new version(140). Here we didn’t change the compatibility level...

• This reply was modified 1 year, 8 months ago by  ramana3327.

Michael is correct, We don’t have readable secondary. I don’t think adding more resources to the physical box is easy as VM.

I tried to run native full backup to local drive. It terminated with the same error message like log full. Does it allow sql backup to local drive when the...

• This reply was modified 1 year, 11 months ago by  ramana3327.

Is it require to have any free log space to take the full back of the database or log backup?

I am seeing that transactional log for database is full due to log_backup messages in the error log whenever I try to run the back. I can’t able to run...

No, I am not seeing those messages in the log.

Select @@ version: SQL 2017 ( RTM -CU22) standard edition on Windows 2016 standard.

From sys.dm_os_sys_info

cpu_count = 8, hyperthread_ratio=4, physical _memory_kb = 16776624, virtual _memory_kb = 137438953344, visible _target_kb = 8388608,...

• This reply was modified 2 years, 1 month ago by  ramana3327.

From task manager under CPU

Sockets: 2

Virtual processors: 8

From Resource Monitor under CPU showing CPU0-CPU7 (only8). Same no 8 cpus from SQL Server Properties. The Max memory is 8gb.

From SQL server...

• This reply was modified 2 years, 1 month ago by  ramana3327.

Processor: Intel(R) Xeon((R) CPU E5-2667 v3 @ 3.20GHZ ((2 processors)

Installed memory: 16 GB

64 bit Operating System, x64- based processor

SQL server Always on is configured on this with just 1 database...

• This reply was modified 2 years, 1 month ago by  ramana3327.

This server is configured in mirroring (principal).

Hi All,

Thanks for helping on this issue. I updated the statistics it initially showed cpu usage is down. I created 2 non cluster indexes for query waiting for cpu &...