Viewing 15 posts - 4,681 through 4,695 (of 7,502 total)
- 10% of 2.6Gb +-260Mb so that explains the file growth
- of that 260Mb (available after auto growth) you have already consumed (260-139) 121Mb.
No problem.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 12, 2008 at 12:39 am
here's a nice overview ...
http://www.sqlservercentral.com/articles/63472/
http://www.codeproject.com/KB/database/SQP_performance.aspx
http://www.mssqltips.com/tip.asp?tip=1556
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 12, 2008 at 12:30 am
Carolyn Richardson (8/11/2008)
See article on this site:-http://www.sqlservercentral.com/articles/Administration/3177/
Written by yours truly :w00t:
I guess I lost track of this forum thread I'd launched myself.
Thanks for adding the link.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 11, 2008 at 6:07 am
hth
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 29, 2008 at 8:04 am
Yuckon (7/25/2008)
...Sorry but I thought you guys on here like a challenge!
This is not a challenge.
The point always is to find a thingy that works, alligned with what's reasonable, and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 25, 2008 at 9:17 am
Yuckon (7/25/2008)
DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.
The reason I want to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 25, 2008 at 8:55 am
- Wouldn't you be better off setting up db-mirroring ?
(maybe even using db-snapshots to use the data you want)
It will keep up with the updates if...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 25, 2008 at 8:44 am
I'm in Toronto this week spending some quality time with the family :w00t:
I'll see if I can get the info you requested.
Johan
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 24, 2008 at 7:17 am
BTW the new drivers are:
HP DL380G5
ComponentFirmwareDriver
Bios P56-01/24/2008-
ILO1.431.13.0.0
Networkcards2.1.2.04.4.21.0
Raidcontroller1.786.12.4.32
Videocard-6.14.10.6744
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2008 at 2:38 pm
GilaMonster (7/21/2008)
ALZDBA (7/18/2008)
And sweet is the odor of victory 😎But sometimes no one acknowleges it ... "after all you just did your job".
The best part was that a few months...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 21, 2008 at 1:15 pm
just a ping back http://www.sqlservercentral.com/Forums/Topic510666-1291-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 19, 2008 at 4:50 am
Oh indeed, sqlserver will try to make its work as easy as possible by grabbing all the ram it actualy needs.
Probably it decided to grab some more because of the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 19, 2008 at 4:38 am
Thank you for providing the extra parameters Jeffrey.
Apparently those weren't in BOL sep. 2007
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 19, 2008 at 4:30 am
I don't have sql2005 on win2003 right now, but according to BOL
you can check it using:
LOGINPROPERTY ( 'login_name' ,
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 18, 2008 at 10:44 am
till today that driver-fixed server has been running fine after the upgrade.
We're planning on doing the same operation on the other 3 servers next tuesday.
No dump, no eventlog, no nothing...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
July 18, 2008 at 10:36 am
Viewing 15 posts - 4,681 through 4,695 (of 7,502 total)