803 reputation
412
bio website spartansql.com
location Minnesota
age
visits member for 3 years, 11 months
seen 2 days ago

A SQL Server DBA living and working in the Twin Cities. Professional interests include replication and T-SQL programming.


Dec
12
comment How can you tell if a SQL Server instance max'ed out bottleneck is CPU or Memory?
A method of determining what the problem is is to look at what the query is waiting on. You can get a point-in-time view of this from sys.dm_os_waiting_tasks and sys.dm_exec_requests. Once you know what it's waiting on, you can either try to reduce your query's need for that resource or increase the amount of it. But without knowing what it's waiting on, saying that adding CPU or memory will help is just a guess.
Nov
21
awarded  Popular Question
Oct
31
answered A query that lists all mapped users for a given login
Sep
24
awarded  Autobiographer
Sep
10
comment Database Properties Error - sys.spt_values missing but dbo.spt_values works?
On a lark, have you tried connecting over the DAC?
Sep
1
awarded  Popular Question
Aug
19
comment Troubleshoot of WRITELOG on new machine running very slow?
From your description, it seems like these are the exact same operations just on different servers. Is that accurate? That is, there's not a change in anything like the batch size for your select into or how many tables are being created in one transaction? How about the recovery model of each db?
Jun
6
awarded  Notable Question
Jun
4
answered How to make snapshot for new tables only
May
28
comment SQL Server Deadlock - Two SELECT Exclusive Locks on Exact Same Index and Key
Is it possible that they were both waiting to escalate the lock from row -> page or page -> table? If so, the other select would prevent that from happening. Also, what's the transaction isolation level of each process?
May
2
answered Backup and Restore of Development
May
2
answered Mirroring between two Ms-sql servers for Migrating server from one Datacenter to other Datacenter
May
1
comment SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc
This is KB 2830400 (support.microsoft.com/kb/2830400) and is fixed in SP1 CU4 or RTM CU7. Just in case CU5 was too much.
Apr
30
comment AlwaysOn Availability Group Automatic Failover does not work
What does your quorum model look like? Is it a simple node majority? If so, that could be your problem. From technet.microsoft.com/en-us/library/cc731739.aspx, that quorum model can only sustain a loss of (half of the nodes in the cluster) -1. So, if you have a two node cluster with node majority quorum, you can sustain 0 node failures.
Apr
14
comment Slow performance of remote restore
The 100% I was referring to was the output from the restore process as a result of having added "with stats = 10" to the restore command.
Apr
14
comment Slow performance of remote restore
Yes, the backup files were remote to the DR system. I'm just confused by the apparent contradiction where it seemed to read the file quickly (or at least as quick as I'd have expected), but then was slow to actually complete the restore.
Apr
14
asked Slow performance of remote restore
Mar
20
comment Accidental Turn On of Replication
If my environment is any indication, no. All of mine are owned by distributor_admin. Besides, a lot of times, tearing down replication will remove the jobs as well.
Mar
19
answered Accidental Turn On of Replication
Mar
17
comment SQL Server 2008 replication and large data updates
I'd question why you're doing a nuke and pave daily. Replication is designed to keep two tables in sync. If you delete all of the data and then insert all new data, that's a 2*(size of table) operation.