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?

Thanks all. The Paging File Usage on Task Manager is indeed badly named. Its the sum of the page file and memory in use. The Counter Page File Usage shows...

Hi Again. I just test AWE extensively and I notice also a lot of page file usage as my buffer_pool_commited_memory_in_GB grew.

My buffer_pool_commited_memory_in_GB grew from about 0.55GB to 7.97GB and my...

Thanks very much people. Just that from some people's posts on the Internet I was beginning to get the impression that I should see this value reflected in the startup.

Fine,...

Hi,

I am using the /PAE switch NOT the /3GB.

The results of the query are below:

physical_memory_in_GB-----------------------------16

VAS_GB------------------------------------------------2

buffer_pool_committed_memory_in_GB-----------1.62

buffer_pool_target_memory_in_GB----------------9.77

Min Server Memory (GB)---------------------------- 0

Max Server Memory (GB)----------------------------9.77