As it's an identity column, the values inserted are always increasing in value so they are inserted at the end of the index. Lowering the fill factor won't improve...

Size will depend very much on the individual environment, but you should try to avoid the need for auto-grow.

Tempdb can be critical to your database server performance and you...

Does the stored procedure have any parameters? Check the compile value for the parameters in the execution plan on dev/production. It's possible that it's a parameter sniffing issue....

Jayanth_Kurup (6/15/2011)

---

I cant think of any severe issues with filling drives to capacity esp if they are not going to grow and no index rebuild etc are gonna happen, and...

The host file is used to provide host name resolution - to convert a name into an IP address. This is a simple text file that you can edit...

I've found that adding an entry in the host file (c:\windows\system32\drivers\etc) of your client machine for the remote server can help with this issue. You would also need to...

The CLR code we are using is very simple:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

<Serializable()> _

<Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.Native, _

IsInvariantToDuplicates:=True, IsInvariantToNulls:=True, IsInvariantToOrder:=True)> _

Public Structure BitMaskOR

Dim val As SqlInt32

...

The server is configured to use 56GB (57344MB MAX server memory) of it's 64GB. Min Server Memory is 0. The service account has the lock pages in memory...

I've just configured database mirroring - same procedure as last time, but this time it worked without any problems and synchronized within a few seconds. 🙂

It's great that it's working,...

Steve Jones - Editor (9/25/2009)

---

Mirrored on this same server? I'm worried that the firewall or network is limiting the comm back from the DR server to the production server. That's...

There is a firewall, but it's been configured to allow traffic on the port used by mirroring....

Steve Jones - Editor (9/25/2009)

---

I would lean towards a bug, or a network issue. Can you try this? Create a small db, say 1MB, mirror it to the DR server....

Jason Shadonix (9/22/2009)

---

You might also look at the perfmon counters on the disk drives of the mirror server. It may be that it's having no trouble sending the log...

Hi,

I didn't like the idea of leaving mirroring in that state during the working week so I switched back over to log shipping. I still want to get mirroring...

Hi,

This is a new mirroring setup - converting from log shipping to database mirroring. The backup that was running was our normal weekly full backup - At first I...