Viewing 15 posts - 121 through 135 (of 184 total)
we have erp system and we get account detail and we have 10 gb bit network card
when we disable large receive offload performance is oke but when we...
September 7, 2011 at 8:14 am
In that time I changed data only data collection feature I look it job history.
August 28, 2011 at 1:14 am
Now it dosent change it is about 213 and 214 gb changing but i cant find where is it use 13 gb memory. because when i take memory consumption report...
August 22, 2011 at 10:48 pm
Oke but why i can not shirink temp db or how can i find the problem because it is 30 gb about now
August 22, 2011 at 1:26 pm
It is production database and suddenly grow and i can t restart server
August 22, 2011 at 1:05 pm
I change it to default values the before dba set it but i change it to normal default.
August 22, 2011 at 3:53 am
Thanks for reply i solve that problem but i have a problem i set i/o affinity and procesor affinity auto and i set server
memory max and min server memory...
August 22, 2011 at 1:59 am
If you are using SQL SERVER 2008 you can create a SQL SERVER TRACE COLLECTION set it is insert to a table your select queries
and you can write a triger...
July 28, 2011 at 5:14 am
I can t understand exactly I m using Data Collection Set for it and i can schedule it one minute or once a time.
If i start the collection set...
July 23, 2011 at 3:52 am
I m writing it into the table it is about mdf space isn t it?
July 23, 2011 at 3:45 am
Viewing 15 posts - 121 through 135 (of 184 total)