matt.newman (4/20/2012)

---

Also will dump a screen capture here just in case it is of help - off topic relates to PerfectDisk. I ran a lot of testing on PerfectDisk but...

kdburger (4/20/2012)

---

I'm just a novice, and probably shouldn't even post to this site. But, I wanted to ask what is likely a rediculous question. How did you 'extend the...

matt.newman (4/20/2012)

---

Remember to check both user databases and system databases. TempDB re-initializes after server restart and goes back to the initial size setting. When you do a restart on the...

It's Vmware.

Each time the database file grow, you may potentially get a new fragment, as SQL Server will have to allocate more space for its file. If there is not enough...

magarity kerns (4/20/2012)

---

I recommend PerfectDisk - I remember we bought it to use on the SQL Server based data warehouse because the staging environment did a lot of updates and...

What settings have you got for growth of database files. Sounds to me that they grow by too little each time. Gain control of the growth of your databases, and...

Will check that out. Cos I...

We definitely did not do that. The performance problems grew over time.

Hello Matt,

I am not sure I know what you mean by growing th database but I did not perform any activity to deliberatly grow the database.

Amazingly, no dwontime was recorded....

Thanks so much Kristian. this is very useful.

I know one can adjust the fill factor to deal with internal fragmentation, what can one do about external fragmentation?

In addition, we use...

We had somethig similar to this on one of our systems. Apparently SQL Server had crashed due to memory issues. We saw several Out of Memory errors thrown by another...

Apparently yo had this error with the Check table Size script:

use AcsData

go

create table #tablesize

(name nvarchar(120),rows char(11),reserved varchar(18),

data varchar(18),index_size varchar(18),unused varchar(18))

go

insert into #tablesize

exec

sp_msforeachtable @command1=

'exec sp_spaceused ''?'''

select * from #tablesize

go

drop...

Which of th scripts did you have this error with? Check DB Size or CHeck Table Size.

Thanks so much SSCrazy. You are the best.

Assuming I was not the person who implemented the instance, how can I fin ou whether there are any COM components?