homebrew01 (10/16/2009)

---

Indexes should be below 10%. Once they reach 10%, they are now using...

GSquared (10/16/2009)

---

Because it tastes better that way.

(Others reading this thread, be aware that the...

SQL Server 2008 no longer includes the group BUILTIN\Administrators, and does not automatically make members of that group sysadmins.

Also, on Windows Server 2008, Vista and Windows 7 - you have...

Well, not quite true - download SQL Compare Professional (Redgate). You can then use the backup file to perform a schema comparison and use the script...

jordon.shaw (10/15/2009)

---

I know that I said I would leave y'all alone, but I lied. Here is a issue, if you look, I'm setting a varible of assetindex to what...

Fraggle-805517 (10/15/2009)

---

Sorry Gila, I mistyped. Obviously, the CXPacket will decrease if I change the setting and turn it off. However, then it will go else where. So...

I am fairly certain that using the target_size parameter to SHRINKFILE will reset the initial size of the database.

Have you tried manually running the following:

DBCC SHRINKFILE(file_name, 260000);

The above should shrink...

What is the max memory setting for that instance? Why do you think SQL Server using 5.5GB of memory out of 7.5GB (leaving 2GB to the OS which is...

How many processors do you have on this server?

You need to review each instances requirements and determine how much they need based upon the utilization of that instance.

Nobody here is going to be able to tell you that,...

WillC9999 (10/15/2009)

---

My concern is the huge disparity between the actual data in the databse (i.e. almost none) and the space is it taking up (1Gb)! Shrinking doesn't seem to have...

You are welcome - glad I could help.

I just read what I posted and it may have...

steveb mentioned backing up the transaction log - are you? You asked:

Here is my issue, I still got the warning log file is full and I did not see...

Did you set the max memory for SQL Server? If not, then you are starving the OS and SSIS which is causing these issues.

Set the max memory to 1024...