Viewing 15 posts - 121 through 135 (of 151 total)
matt.newman (4/20/2012)
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 1:24 pm
kdburger (4/20/2012)
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 1:21 pm
matt.newman (4/20/2012)
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 1:20 pm
npcrwill8 (4/20/2012)
Curious if this instance might be running in VMware or MS virtual machine ?
It's Vmware.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 1:19 pm
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...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 12:20 pm
magarity kerns (4/20/2012)
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 11:59 am
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...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 11:54 am
magarity kerns (4/20/2012)
Did you consider a third party disk deframenter like PerfectDisk? It does not have the free space requirements of the Windows defragmenter..
Will check that out. Cos I...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 11:31 am
We definitely did not do that. The performance problems grew over time.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 11:29 am
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....
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 10:12 am
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...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 20, 2012 at 8:14 am
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...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
April 10, 2012 at 5:28 am
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...
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
March 30, 2012 at 1:12 pm
Which of th scripts did you have this error with? Check DB Size or CHeck Table Size.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
March 30, 2012 at 1:08 pm
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?
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
March 23, 2012 at 10:03 am
Viewing 15 posts - 121 through 135 (of 151 total)