Carl Federl (3/9/2010)

---

Have you checked the transaction log for a large number of Virtual Log Files by running dbcc loginfo() ? A large number of VLFs will cause slow...

thanks for the reply. So splitting up the data into to 2 or more databases is a "done" thing then. Can i ask how you both managed the transfer of...

SQL Noob (3/9/2010)

---

our 2TB databases have tables with over a billion rows that recover faster than the 700GB database we ended up splitting up where the tables were only a...

SQL Noob (3/9/2010)

---

we have databases from a few MB to almost 2TB. we had a problem with a database in the 700GB range that would take 2 hours to recover....

REF GilaMonster reply:

Interesting, the checkpoint idea may help. Still have the problem of re indexing a large table or restoring or transfering to DB to R&D. Much of my 300Gb...

Interesting article. I must admit I am very goal driven outside work, budgets and plans to a very fine degree. Never really thought about applying the same logic to my...

i.e is this happening if i have a constant flow on INSERTS and a user runs a read query ?

INSERT (Exclusive Lock start/stops)

Read starts

Read paused

INSERT (Exclusive Lock start/stops)

Read continues

Read...

Thanks for the reply. Been chatting to a SQL contact at an ISP and he also mentioend NOLOCK (see below). taking into account what everyone has said in this forum...

Thanks for the reply.

I woulnt allow direct connection to SQL 🙂 but thanks for pointing it out the "no no's" 🙂

Possibly allow a web app to managed the seleciton of...

thank you.

Steve Jones - Editor (2/3/2009)

---

Scott,

You've got quite a problem here and I'd really suggest engaging a consultant that can help you with more detailed designs for your environment.

You are tackling...

mirroring does seem sensible to me. but 2 points (basically my inital 2 problems)L

1. im using an a/p cluster, if one db can do into recovery mode for 30 mins...

santhu (2/3/2009)

---

Hi all,

Now I understant. it is the problem with sql 64bit with sp2. The database mail doesnot interact with SSA. Either we need to use SQL Mail(using outlook Express)...

ALZDBA (2/3/2009)

---

scott_lotus (2/3/2009)

---

Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT...

Microsoft SQL Server 2005 - 9.00.3233.00 (X64) Mar 6 2008 21:58:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build...