charshman (8/26/2008)

---

It's hard to tell offhand what exactly your problem is, but I did have a couple of suggestions...

Your Maximum Server Memory for your SQL Server instance probably should not...

Here's a sample of notable errors:

08/25/2008 09:59:37,,Error,[298] SQLServer Error: 258 Unable...

GilaMonster (8/26/2008)

---

On 64 bit systems you should limit the max memory. SQL's quite capable of taking all tha available memory and starving the OS. Try setting it to 6.5GB. Dunno...

Windows and SQL Server are installed on c:master, model and msdb databases and log files are on c:tempdb, user databases and log files are on f:

I'm using a 64 bit...

Sam,

Here are the responses to your questions:

1Q. What are your memory settings in sql server?

1A. What sql server memory settings are you referring to? And how do you access those?

2Q....

Perry,

What perfmon counters would you use?

My only concern is that the developer's code might not be the problem. If that's the case, what steps should I use to rule...

What perfmon counters would you use?

My only concern is that the developer's code might not be the problem. If that's the case, what steps should I use to rule...

GSquared,

Thanks for the info. I downloaded ApexSQL and used it to synchronize the databases. However, I ran into the following error:

Can't execute script against database. Exception of type 'System.OutOfMemoryException' was...

Jack,

The database already exists in production. Even if it didn't exist, I'm not sure how feasible that option would be. I'm guessing the truncated database would be 1-2GB.

Thanks for your...

GSquared,

On the production server, an older version of the database exists. For this next database version, the majority of existing tables will be truncated or removed. The rest of the...

How do you access DTS and the "copy object wizard" in SQL Server 2005? Are you referring to the "SQL Server Import and Export Wizard"?

Do any tools exist natively to SQL Server 2005? Or are 3rd party tools the only option?

Thanks again.

Grant,

That sounds like good advice.

How would you implement the corresponding computer_config_state? Is either one of the following options better than the other? Or is there a better option?

1. computer_config_state as...

Actually, I was mistaken. Using an is_active bit will work. However, if I ever need to add another type of "computer_config_state", I'll be back to the same problem.

Using an is_active bit won't work because i need to keep a history of active/inactive dates. If multiple active (or inactive) dates appear, I won't be able to store that...