Hi George,

Thanks for the comments, I am in a position where a large portion of the servers I build/look after have the potential to be audited by an external firm.

I...

just a side thought (in relation to the buffer cache, working sets, paging etc) I am presuming the SQL run time account have the "lock pages in memory" privledge under...

Hi Brian,

Further to this article: what services are required to be running on the SQL server?

I presume Kerberos Key Distribution Centre service has to be activated on the SQL...

K. Brian Kelley (4/30/2009)

---

Carlton Leach (4/29/2009)

---

Hi Brian, Great article I agree.

I am having trouble getting Kerberos set up tho.

I am using:

- a Virtual Machine (VMWare)

- sql 2005 SP3

I have...

Hi Brian, Great article I agree.

I am having trouble getting Kerberos set up tho.

I am using:

- a Virtual Machine (VMWare)

- sql 2005 SP3

I have run the 4 steps adived:...

I like Gails recommendation of a lightweight trace to monitor whats going on and when.

I would also consider using DDL triggers, have a look in BOL for "Designing DDL Triggers".

Carlton..

I hate cursors...hence I like this article.

I have stated my opinion a few times on SSC "Cursors are only useful if you don't know how to write SQL".

to anyone who...

In SQL 2008 u could log/audit any statements run across the suspected DB's.

Or just.

You could use a trigger on the connection event.

But the auto-close idea could be a Q and...

It is a new feature in 2008 (I think only in enterprise version mind you) that lets you create resource pools to throttle performance for certain processes eg. MAX cpu...

Access uses a cursor API?!

thanks Mohit I've learned something today 🙂

This is where the resource governor for 2008 could come in handy...

Carlton..

I agree.

I would use:

- activity monitor

- profiler

- exec plans

Look for cpu usage, also heavy read/write counts from your trace may help you identify what is doing it.

Someone said:

"Tune the code,...

Jeff Moden (3/13/2009)

---

foxjazz (3/13/2009)

---

Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on...

s

"Cursors are only useful for people who don't know how to write SQL"

a few things you could try:

- grant the runtime account explicit permissions to the directory

- try creating a folder called 2008backup or something in that directory, does it behave the...