If you T-Log backup size is increasing then I would check to see if anyone is doing batch imports, Index rebuilds, jobs etc. SQL Server cannot backup what has...

Aye it will be a life savor :).

I been tuning for about 2.5 years now and can't live without it. In SQL 2005+ however use the one that comes...

Excellent :), I wanted to ask the normal questions. Because didn't want to have to go over something and realize we missed something heh.

As for what could...

If the users have SYSADMIN no other permissions are checked; they super seed all permissions. In production environment no user other then service account, SA and DBA group should...

Hi David,

Question, is that 64-bit or 32-bit. If 32-bit do you have the AWE enabled?

Mohit.

rholland82 (4/16/2009)

---

Long story short, I have a crazy demanding client that wants to do a side by side install of 2005 (same version). aside from the obvious...You don't have...

Hi Chris,

This is how approach it; I start up PSSDiag and start recording SQL Query times and KPI (Key-Performance-Indicators); I show them how long a query should take....

How much memory on your server? What is OS? What Edition of SQL Server? And what is your Max/Min settings?

Mohit.

Don't mind me asking if the people you are sending this document to will not understand the reasoning for it; why do you want to send them the execution plan?

Mohit.

It is and a very good book I tell all developers to read this, saves me headache later -.-.

Link: http://downloads.sqlservercentral.com/dissecting_contents.pdf

Wilfred van Dijk (4/17/2009)

---

Hi,

We had a discussion about mirror commit overhead and what an acceptable overheadtime is. Right now the overhead is 2-5 milliseconds per commit. In my opinion, this...

Thanks for feed back .. hmm Display Header Only? LOL I guess they can't copy Microsoft LOL.

Thanks again 🙂

Glad you got it to work, I usually use http://sqlserverbuilds.blogspot.com/[/url] to find...

As Nick said check the logs; but few things that might be causing the services to startup are communication failure. When the services die do you see that the...

You CPU usage is high; could it be there is CPU pressure? Delaying the execution of the query? If you can post the query and attach the execution...

rew (4/16/2009)

---

DBCC SHOWCONTIG scanning 'Accounts' table...

Table: 'Accounts' (1246627484); index ID: 1, database ID: 8

TABLE level scan performed.

- Pages Scanned................................: 38095

- Extents Scanned..............................: 4795

- Extent Switches..............................: 30740

- Avg. Pages per Extent........................:...