Viewing 15 posts - 3,241 through 3,255 (of 7,506 total)
why would you only allow sa to connect ?
Is it for sql server (software) maintenance ?
You could start sqlserver using the maintenance parameter. (check books onlin for startup parameters...
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
January 3, 2010 at 3:08 am
You are probably on the right track ...
tempdb is used for way more activities than just holing the data for temporary tables. Cursors, sorts, group by, intermediate results for working...
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
January 1, 2010 at 4:37 am
I would first restrict the growth of tempdb, so it doesn't fill up your disk.
I would start a sqlserver profiler session to capture the ongoing queries.
You'll probably find a set...
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
December 31, 2009 at 9:32 am
of course you should also pose the question : WHY ??
If this is some kind of "primitive" encryption, SQLServer nowadays has a better alternative !
Is it to confuse network sniffers...
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
December 30, 2009 at 12:11 pm
start from scratch !
create a new windows account with no privileges at all ( none on windows, none on sqlserver)
Then grant that account only the needed auth on your sqlserver...
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
December 30, 2009 at 12:03 pm
btw there is a sql7/2000 version posted in this forum thread:
http://www.sqlservercentral.com/Forums/Topic512777-338-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
December 30, 2009 at 2:36 am
Vinay Thakur-585143 (12/29/2009)
can you please brief about:
"Maybe one of your processes keeps a permanent lock on one of your objects."
also how can be "deadlock happen" as reindex is run...
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
December 29, 2009 at 3:02 pm
restart your rebuild index process and monitor for (dead)locking .
Maybe one of your processes keeps a permanent lock on one of your objects.
We have had such a case a long...
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
December 29, 2009 at 12:19 pm
cfr "don't need to understand code in a object oniented programming language, just use it"
You'll still need to desing your objects, but in the cloud, you shouldn't need to worry...
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
December 29, 2009 at 11:12 am
Keep in mind with a trigger you can use the "inserted" and/or "deleted" objects !
You could just store that info in an audit or logging table an work it out...
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
December 29, 2009 at 11:06 am
With that kind of messages, I would first run a
DBCC CHECKDB
It checks the allocation and structural integrity of all the objects in the specified database.
DBCC CHECKDB ( 'database_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
December 29, 2009 at 11:01 am
We always perform full maintenance after any migration.
i.e.
rebuild all indexes (explicit)
exec sp_updatestats or UPDATE STATISTICS table / view WITH FULLSCAN
dbcc updateusage(0) with count_rows
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
December 29, 2009 at 7:14 am
Jeff's advise is indeed the best starting place.
Clustering (a/a - A/p) can be used to host clustered sqlinstances.
Load balancing isn't in scope for sqlserver yet ( I didn't check this...
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
December 27, 2009 at 4:06 am
I would suspect your connection isolation level to be more intrusive than the one SSMSexp uses (read committed).
What isolation level are you using ?
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
December 26, 2009 at 4:43 am
Indeed with 64 bit you should always set the max memory configuration or it may actually eat up all your physical ram.
IF you want to get control of processor %...
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
December 25, 2009 at 2:41 pm
Viewing 15 posts - 3,241 through 3,255 (of 7,506 total)