53 reputation
6
bio website
location
age
visits member for 1 year, 11 months
seen 1 hour ago

Jan
21
asked Moved database to new server, not sure about NT AUTHORITY\* users
Oct
25
awarded  Commentator
Oct
25
comment Is database partitioning for performance reasons meaningful in virtualized environment?
Of course there are physical disks but you are not accessing them directly. Behind your drive C: you can have pieces of multiple discs from some kinds of network connected storage. And placing you database on C: drive and log on D: in virtual environment doesn't mean they will actually end up on different spindles. Does this make it clearer?
Oct
22
comment Is database partitioning for performance reasons meaningful in virtualized environment?
Virtual environment can have logical disks (as in different drive letters). However, these logical discs are created by an array of physical discs, and you really have no way of knowing how many physical discs are behind the logical disc. That being said, it is probably possible to have one logical disc based on mechanical array and another - on SSD array.
Oct
22
comment Is database partitioning for performance reasons meaningful in virtualized environment?
I was not asking about separating physical discs. There are no physical disks in virtual environment, hence the reason for my post.
Oct
21
awarded  Editor
Oct
21
revised Is database partitioning for performance reasons meaningful in virtualized environment?
added 134 characters in body
Oct
21
asked Is database partitioning for performance reasons meaningful in virtualized environment?
Mar
18
comment Getting timeouts and backup errors after mirroring and log shipping is setup
What's the deal with not being able to edit my own comments? The above should say "...from every 5 minutes for all 3 databases to every 20 minutes for 2 databases and every 5 minutes for 1 database. ..."
Mar
18
comment Getting timeouts and backup errors after mirroring and log shipping is setup
A bit of an update: 1) I changed log backup frequency from every 5 minutes for all 3 databases to every 2 minutes for 2 databases and every 5 minutes for 1 database. I also staggered them in time. This seems to take care of log backup failures and "insufficient memory" messages. 2) I also removed mirroring from 2 databases completely (every mirrored database accounts for 2 connections) and left it active for 1. Timeouts are still occurring.
Mar
15
comment Getting timeouts and backup errors after mirroring and log shipping is setup
Highest wait by pct_wait_time is DBMIRROR_SEND (82.7%, 5022 ms) but could it be skewed because I kept mirroring suspended for the last several hours for one of the databases? Second highest is PAGEIOLATCH_SH (11.0%, avg 94.2 ms)
Mar
15
comment Getting timeouts and backup errors after mirroring and log shipping is setup
Mirroring is set to "High Safety without automatic failover". There is no witness. Insert/update activity on the primary is really low, so I don't think mirror not being able to keep up is an issue.
Mar
15
comment Getting timeouts and backup errors after mirroring and log shipping is setup
4) 99% log backups take 0 sec to complete, the rest are 1-3 sec. 5) Staggering log backups, making them less frequent and upgrading hardware is being considered (yes, that server is probably 6-8 years old)
Mar
15
comment Getting timeouts and backup errors after mirroring and log shipping is setup
Mike, Your reply us appreciated. Here are answers and more questions: 1) Will enabling AWE at least help some with 4 GB of RAM? I can give SQL 2.5 GB max memory for instance. 2) I ran query for wait stats you linked to. In the first set of results (since server was started) this is what it looks like for BACKUPTHREAD : sum_wait_time_ms=5796846 pct_wait_time=0.1 sum_waiting_tasks=236073 avg_wait_time_ms=24.6 3) SQL Server: Buffer Manager -> Page Life Expectancy is about 54,000 (avg) - is that considered low?
Mar
15
comment Getting timeouts and backup errors after mirroring and log shipping is setup
Databases are not that large - one is 300 MB, another is 500 MB and another is 1.2 GB. Memory/Available MB counter i 1048 Min, 1081 Max
Mar
15
asked Getting timeouts and backup errors after mirroring and log shipping is setup
Mar
12
awarded  Supporter
Mar
12
asked Can the same database be log-shipping secondary and primary at the same time?
Mar
3
awarded  Tag Editor
Mar
3
revised sql-server wiki description
Updated edition description