High Disk Write Bytes/sec In Mirror Server

Oct 4, 2006

I have do some benchmark test between the "Principle", "Mirror" and "Witness", things seems normal, the System usage (CPU, Disk Read/Write) on the "Witness" is very small and the CPU usage on Principle and Mirror is similar, However....

For the "Disk Write Bytes/sec", the usage on Principle is 200,000 and the Mirror is 1,500,000, the mirror server is talking about x7 times Disk Write Bytes/sec on the Mirror.

I cannot think of any reason why the Disk Write Bytes /sec is so much higher than the Principle, can somebody help me?

View 2 Replies


ADVERTISEMENT

SQL Server Freezes : Consumes High Disk Space

Dec 19, 2005

Hi,

The SQL Server Database hangs overnight and also consumes high disk space on one of our servers. This has been recurring for quite a few weeks and occurs daily.

Can somebody assist me in trouble-shooting the same

Thanks in Advance
Deepak

View 3 Replies View Related

High Disk I/o

Aug 14, 2002

Hello,

We are experiencing high disk i/o on one of our RAID disk systems. Can someone tell me how I can identify the query or user or process which is causing this high disk i/o?

Thanks,
Brent.

View 1 Replies View Related

Mirroring :: Async Mirror Setup For High Number Of Databases

Oct 27, 2015

I have a 2 node cluster having 4 cores each wherein having 3 instances of SQL 2008 R2 enterprise comprising of 60 databases, 20 on each instance. I need to setup mirroring for each of the databases to a secondary server having 4 cores and 3 instances.

What i understand is that in this case the mirror server will be providing max of 512 worker threads and the 60 mirror databases would consume 240 threads.

What all needs to be checked for looking into the feasibility of going ahead with a async mirror setup as mentioned above.

View 4 Replies View Related

Disk Write Caching

Nov 30, 2007



What's the best practice when it comes to disk write caching? Is it better to enable or disable this feature?

Thanks.

View 5 Replies View Related

Mirroring :: How To Reduce LDF Size While Mirror Enabled With Mirror And Witness Server

Jun 14, 2015

I am using SQl Server 2012 Database Mirroring with around 40 gb as mdf and 1 gb as ldf. Now my ldf size increased . How to reduce ldf size while mirror enabled with mirror server and witness server. Can shrink the ldf with mirror enables.

View 4 Replies View Related

SQL 2012 :: Disk Write Every 2 Minutes

Feb 5, 2015

During investigation problem with disk i found some issue, that every 2 minutes is writing on disk , it looks like to mdf file of database, but in almost 6-8milions Bytes / sec , it is about 1-2 sec , but every 2minutes... this is normal behaviour ? this is synchonyous writing to disk from memory.

View 4 Replies View Related

SQL 2012 :: TEMPDB High Avg Write Wait Time On Data Files

Apr 15, 2014

I am currently investigating aa high avg write time ms issue (145ms) which seems to be only occuring on the tempdb data files.I have followed the recommended setup of TEMPDB in that

1. Data files = number of physical cores
2. Data files and logfiles are on separate partitions away from the other databases.
3. Tempdb is presized and no incremental file increases look like they are happening with frequency.

We have sharepoint 2012 setup on other sql servers and with TEMPDB setup following the same guidelines, with far more Sharepoint activity on a similary specified hardware which is why its confusing.FileIO auditing on the partitions themselves shows that the FileIO is very fast on the partitions that the tempdb data file which leads me to beleive that Sharepoint may be the culprit perhaps due to excess use of tempdb with operations taking a long time to resolve.

View 3 Replies View Related

Is It Possible To Write A Format File That Skips A Few Bytes Of Header In Data File?

Jul 23, 2005

Hi,I am trying to use BULK INSERT with format file. All of our data hasfew bytes of header in the data file which I would like to skip beforedoing BULK INSERT.Is it possible to write format file to skip these few bytes ofheader before doing BULK INSERT? For example, I have a 1 GB data filewith 1000 byte header. Except for first 1000 bytes, rest of the data isgood for BULK INSERT.Thanks in advance. Sorry if it is really a dumb question as I am newto BULK INSERT and practicing still.Bob

View 7 Replies View Related

SQL Security :: What Is Average Disk Sec / Write In Perfmon Counter

Jul 28, 2015

We are collecting perfmon counters every 15 second . Among the counters is Average Disk sec/Write . I under stand that it is the average time taken in second to write a data to the disk. However I do not understand what the is quantum of data written in one second. What is the measure or unit  of data in Average Disk sec/Write or is it simply the average time taken for an I/O write request.

View 4 Replies View Related

Mirror And Witness Connection In A Disconnected State Immediately After Adding Witness Server To Mirror Session.

Jan 31, 2008


After adding the Witness Server to the Mirror session, the Witness Connection state between the Mirror and Witness Connection is Disconnected and the state between Principal and Witness Connection is Connected.

The procedures defined in Books Online was used to setup Database Mirroring...when the Witness server was added to the Mirror session, only the alter database T-SQL statement was executed on the Principal server.

ALTER DATABASE <db_name> SET WITNESS = 'TCP://<servername>:<port>'

After executing the above statement, a few seconds later the state between Principal and Witness Connection changed to Connected and the state between Mirror and Witness Connection remains Disconnected.

The Mirror session is not using Certificates, every server is on the same domain, using the same domain login account, and all servers have SP2 installed running Enterprise Edition.

Any idea's why the state between Mirror and Witness Connection remains Disconnected?

Thanks,

View 9 Replies View Related

Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?

Dec 28, 2006

hello,all
          I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure)   from C Disk to D Disk(its space is very large) .
         is it possible to do it ? 
         if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal  report connectstring ) ?
        thanks in advanced!
 
 
 
      

View 1 Replies View Related

SQL Server, Disk Arrays And Disk IO

May 7, 2004

Hi all,

Ok here goes,

I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.

So my options as I understand it are:

Get Enterprise edition

or

Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.


I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.

Does anyone know how much performance increase I will get from using two arrays as opposed to one?


Any other advice on this scenario would be greatly appreciated.


Thanks

View 4 Replies View Related

High Availability To High Protection Without Reconfiguring Mirroring

Apr 23, 2007

Hi,

Is there a way to configure mirroring to go from High Availability to High Protection without having to reconfigure Database Mirroring? Using the interface in Management Studio, I can change the configuration option to High Performance, but not High Protection despite both of them being Synchronous.

If not, what are the recommended steps to configure the mirror once it already has been configured? Is just like initially setting up the mirror or would there be any shortcuts I could take? If I stop the mirroring and remove the witness, will the High Protection option be available?

Thanks,
J.

View 3 Replies View Related

High Safety Changed To High Performance After Fail Over ?

Mar 6, 2008

Hi There

I realise this is a stupid quesiton but i cannot really find any confirmation of this in BOL.


If you are running High Safety with automatic failover, when failover occurs does this automatically change to High Performance mode. SInce for failover to occur something has happen with the primary , it will be impossible to commit transactions on the new primary and mirror asyncronously since 1 of them is no longer available.


So am i correct in assuming that automatic failover also automatically changes the mode to High Performacne for that session?

Thanx

View 4 Replies View Related

How Much Bytes Needed In Sql Server

Jun 13, 2007

Hi i want to know how much bytes will sql server take to store asingle alphabet like "a". i need to know similarly for all data types(including images).here i am doing a application where i need topredict the amount of space required in sql server to store the userfed dynamic data.Give me a handy solution.Regardsvisu

View 5 Replies View Related

Mirror Database-How Do I Remove It From Being The Mirror

Dec 27, 2006

I was trying to test mirroring and now would like to delete the mirror database but it says I need to remove database mirroring first. I deleted the endpoint and cannot figure out how to remove the mirroring. Can someone please help.

View 1 Replies View Related

Is It Posible To Put More Than 4000 Bytes Into One Column? ( Sql Server Mobile )

Oct 11, 2006

varchar can only hold 4000 bytes
and there is no text column in sql server mobile

View 6 Replies View Related

SQL Server Job/Step Active X Script &&> 3200 Bytes?

Sep 10, 2007



This must have frustrated a few people. I was putting the final touches to the VBScript in a Step of a SQL Server Agent Job when I exceeded the limit of 3200 bytes. I was obviously unaware of this limit until I hit it.

Is there a way to increase the limit?
Does it still apply in SQL 2Server 2005?

I worked around the problem by converting it to a DTS ActiveX Script Task. A bonus was the you actually get line numbers in the editor although I had pretty much finished debugging by then. I assume that I could do the same in SSIS for SQL Server 2005.

I considered creating a VBS file and executing it from an Agent Job but then the file would not get backed up with one of the system databases. With the script in an Agent Job or DTS Package, it is backed up with either the system or master database (I never can remember which) making life a little simpler during disaster recovery.

I would appreciate any comments.

Dick Campbell

View 4 Replies View Related

Calculating COUNTER Physical Disk: AVG. DISK QUEUE LENGTH

Sep 10, 2007

If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.

View 1 Replies View Related

Get Total Disk Size And Free Disk Space

Nov 13, 2007

-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)

SET@Drive = 97

-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)

WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''

INSERT@Drives
(
Info
)
EXEC(@SQL)

UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL

SET@Drive = @Drive + 1
END

-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive

E 12°55'05.25"
N 56°04'39.16"

View 16 Replies View Related

Should The Quorum Disk Be A Physical Disk Or Majority Node Set?

Nov 15, 2006

Hello,

I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.

John

View 4 Replies View Related

Disk Crash Of Disk That Contains The Paging File.

Feb 20, 2001

Hello,

this is my configuration :

1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.

What will happen to the SQL data (DB) when the disk that holds the paging file crashes?

Kindest regards,
Luc.

View 1 Replies View Related

SQL Server 2008 :: Length Specified In Network Packet Payload Did Not Match Number Of Bytes Read

Mar 2, 2015

Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: xxx.xx.xxx.xx]

Client IP address is same as the server its producing the error on. I get these messages around 12pm everyday.

View 3 Replies View Related

Server Mirror

Dec 19, 2006

Hi all,
I feel happy to post my first thread at dbforums.com, and I think it's the community of DB professionals.
my question is:
I have two servers in my organization, one of them is running an SQL server database. Is there any way to make the second server a mirror of the first one and to make it runs automatically as the main server when the first server is down?

Thanks for replying soon.
Haytham

View 4 Replies View Related

Need To Mirror Access 03 With Sql Server 05

Nov 21, 2006

I have an access database, I am new to the SQL SERVER scene. How do I mirror the database I have in Access with out it being interrupted from its functions?

--David

View 1 Replies View Related

LIMITs On MIRROR With SQL Server SE

Jul 2, 2007

Hi folks. I'm trying to clear up some licensing confusion I"ve come across. First, if I use MIRROR on SS SE I am limited to a single REDO thread and Sycn mode. I see that on the Web. Will the singel REDO thread hurt the ability for the Secondary to keep up? Any one done any tests?



My confusion comes from a document that came across my desk a long time ago that showed that if you use MIRROR on SQL Server SE you are limited to 4 processors for the entire cluster. So if you wanted a balanced failover you would have to have two 2-ways in essence. Is this true? Is it not longer true? I can't seem to find any mention of this....did someone give me bad advice? Help! Thanks.

View 4 Replies View Related

Mirror Monitor Error: Server Replication Requires The Actual Server Name To Make A Connection

Oct 17, 2007

I'm getting the following error when launching the database mirroring monitor and attempt to connect to my database.


TITLE: Connect to Server
------------------------------

Cannot connect to dborat01.hs.pitt.edu.

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'xxxxxx'. (Replication.Utilities)

------------------------------
BUTTONS:

OK
------------------------------

View 3 Replies View Related

What Should The Maintenance Plans Be On Your Mirror Server?

Apr 21, 2006

If your principal fails and your mirror assumes the main role and it is in Full recovery mode (which it has to be in Standard edition), then the log files will grow and grow until a transaction backup and shrink is executed.

I have maintenance plans running daily (and hourly for transaction log backup/shrink) on my principal, but nothing on my mirror.

Do I need to set up the same maintenance plans on my mirror server???

Thanks

Ed

View 19 Replies View Related

Run Time Get Server Name From Db Mirror Enviroment

May 7, 2008

Hi,

I have SQL 2005 database mirrror enviroment with MS jdbc driver 1.1. From code, I need to get server name that current connection connect to at run time (which server that the current connection connect to: Priciple server or mirror server). Any help for that?

Thanks a lot!
Li

View 1 Replies View Related

SQL Server 2005 Failovery From Only Mirror DB

Nov 20, 2006

Hi Everyone;

I have a SQL Server 2005 DB server (SRV1) and a mirror DB server (SRV2) without witness server. I saw that there is a "Failover" button on Mirror window of SRV1. When click it servers changes roles.

My question is that: If my mirrored DB server crashs and I can not open windows or if I lost all data on SRV1, how can I failover from only mirror DB (SRV2)?



Thanks in advance.

Senol Akbulak

View 6 Replies View Related

Mirroring :: Migrate Mirror Database To New Server

Apr 14, 2015

I need to migrate my SQL server Mirror Database to a new server. my current setup is as below

1. server A principal (192.168.1.100)

2. server B Mirror     (192.168.1.200)

Now i have a new server (Server C) to replace server B as below

1. server A principal (192.168.1.100)

2. server C Mirror     (192.168.1.300)

My question is how to migrate mirror db to new server without any affect or downtime on principal server.

note: SQL SERVER 2008R2 EE(64BIT), Win2008R2 EE 64bit.

View 5 Replies View Related

Can You Mirror To Multiple Instances On Same Server Via One Endpoint?

Oct 29, 2007



Hi all,

Can a MIRROR server have mirrored databases on many instances or must all of the mirrored databases on a server reside on one instance?

This initial implementation worked fine:

PRINCIPAL ServerPROD1instance01 endpoint1430
MIRROR ServerDRinstance01 endpoint1440
WITNESS ServerZ endpoint1450


This second implementation (different PRINCIPAL server to same MIRROR but to a different instance)

PRINCIPAL ServerPROD2instance5 endpoint1430
MIRROR ServerDRinstance02 endpoint1440 <<same mirror server but different instance
WITNESS ServerZ endpoint1450


I know that you can only install one endpoint on each server. Does that mean that the endpoint can only resolve to one instance though?

The second implementation looks fine until the final step (start mirroring). I get the following error:


An error occured while starting mirroring
Alter failed for database 'test'
An exception occurred while executing transaction-sql statement or batch
The remote copy of database 'test' does not exist. Check the database name and resissue the command

I have created the test database in instance02 and rolled a log onto it. It is currently in recovery mode - waiting patiently for another log.....

I have read books online and 2k5 unleashed but can't see anything that relates to an implementation across mutliple instances on the DRmirrored servers.

Has anyone tried to do this? Can you confirm its possible?

Many thanks in advance...

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved