Arsh

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 335 total)

RE: Very erratic performance in last few days.

Did you look at ASYNC_NETWORK_IO wait type trend at time . Check this in conjunction with inputs from network team .

February 19, 2018 at 11:36 am

#1980309
RE: Regarding Mirroring setup - TCP/IP network issue

Arsh - Monday, February 19, 2018 11:11 AM
Taking further, you need to have a service account for running both the SQL servers.
Mirroring...

February 19, 2018 at 11:24 am

#1980307
RE: SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

anjang2k - Thursday, November 30, 2017 11:08 PM
At present we normally do the above mentioned steps once in 5 days.We backup...

February 19, 2018 at 11:21 am

#1980306
RE: Regarding Mirroring setup - TCP/IP network issue

SQLisAwE5OmE - Friday, January 12, 2018 2:37 PM
Hi Team,
I tried setting up DB mirroring between PRD & DR side and I am...

February 19, 2018 at 11:11 am

#1980302
RE: INSERT running slow in SQL 2016

coolchaitu - Wednesday, January 24, 2018 11:24 PM
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....

February 14, 2018 at 11:28 am

#1979790
RE: index was outside the bounds of the array

The version your using to connect has to be equal or higher than the one your connecting to. So it should be minimum 2014 or higher in ur case...

February 14, 2018 at 10:24 am

#1979776
RE: Can't get rid of databases

Why do you want to uninstall the SQL server instance when you only want to get rid of the databases (better to share what u r trying to fix) ? ...

February 14, 2018 at 7:13 am

#1979729
RE: Huge table.and poor performance.

Looking at the code would give a much better idea about what's happening . Hence please share the query here. Most of the times the real culprit turns out to...

February 14, 2018 at 7:09 am

#1979727
RE: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. provider: SSL Provider, error: 0

If this happens without any change applied the system , I suggest you check with the infrastructure for any network latency at that time.

February 14, 2018 at 7:01 am

#1979723
RE: Index Fill Factor

I acknowledge what you are saying and agree. . My mention of scenarios represents bigger picture.I would try to write a post as I get docs for backing up .The...

February 6, 2018 at 9:28 pm

#1978810
RE: Index Fill Factor

Thanks George for sharing the docs.

February 6, 2018 at 9:20 pm

#1978809
RE: Delete from very large multiple tables

Lynn Pettis - Monday, February 5, 2018 12:37 PM
Well, replication throws a wrench in what I would consider unless it is...

February 6, 2018 at 1:21 pm

#1978772
RE: Index Fill Factor

patrickmcginnis59 10839 - Tuesday, February 6, 2018 11:18 AM
I don't agree with the answer.
Fill factor is available for viewing in the view (?)...

February 6, 2018 at 1:14 pm

#1978768
RE: Index Fill Factor

Thanks David , George and others as well for compliments and sharing more related info. I'll definitely share the doc I referenced if I can as I go through my...

February 6, 2018 at 9:49 am

#1978734
RE: Shrink all user database files

Not encouraged , unless the downside of this resulting in fragmentation and other stuff put by Jeff , can be dealt with. The lower costs of storage these days make...

January 21, 2018 at 1:02 pm

#1976664

Viewing 15 posts - 76 through 90 (of 335 total)