colin Leversuch-Roberts (9/18/2008)

---

but none of this directly relates to issues with agent worker threads which have little to do with the actual user connections.

If you have hyperthreading enabled you should...

Thanks!! 😀

I just got my MCITP certification and I have been trying to apply all the great stuff I learned to my current environment. I still have a long...

colin Leversuch-Roberts (9/17/2008)

---

I'm going to ask what I normally ask - do you have problems with waits and schedulers and are you monitoring them so that you see this problem,...

Hi,

Here are some answers to your questions below:

1) exactly WHAT performance problems are you having, and what have you done to determine the cause and symptoms?

we were having...

Hi,

Based on the queries, it looks like it's okay for now:

max_workers_count = 352

count from sys.dm_os_threads = 147

Thanks again! 😀

Isabelle

Thanks for the info.

I am currently looking into other areas of contention as well so I guess I will leave the default value for the worker threads. I know...

I used to be more active in my younger years and now that I am approaching the big 40 with two young kids (4 and 2 years old) I find...

Thanks for pointing that out. I was doing that exact thing! I did not realize that our indexes have that option set and my job was updating statistics...

Hi,

Thanks for the replies! So Matt, what you are saying is that you didn't use the log shipping functionality but instead just copied modified data over twice a day...

Hi,

It is a local group on the server.

Thanks,

Isabelle

Hi,

Yes, I have posted this also in the Microsoft forums. We have another Windows 2008 box with SQL 2005 that is being used for our web and it does...

Hi,

We still have not applied the SP2 on our production server and have not seen any more memory pressure errors since we put the -g512 switch parameter in our startup....

Hi,

I was unaware that shrinking the log causes such havok on the internals of your database :blink: I have our production database scheduled with log backups every 15 minutes...

Hi,

We haven't experienced the memory pressure issue since we implemented the -g15 switch. I have applied the SP2 update on our test server (9.0.3186) but my boss wants me...

Doh! :blush:

You are absolutely correct! I can't even believe I didn't see that! It should have clicked when I responded to you that there are no...