Viewing 15 posts - 451 through 465 (of 860 total)
yisaaacs (3/27/2009)
Hi everyoneis there anyway i can automate checking whether SQL server agent and the SQL service is running,
but also notifying certain people via email that its down...
thanks
You can use...
March 27, 2009 at 4:21 am
Yes, that's true number of tempdb data files should be equal to the number of core CPU's which gives you considerable performance and also the data files should be of...
March 26, 2009 at 5:30 pm
And also some interviewers try to scare you. You don't have to, be confident as long as you know the right answer and that depends on your experience and how...
March 26, 2009 at 5:18 pm
And on top of what mohit advised, each tempdb data files should be of equal size.
March 26, 2009 at 5:07 pm
shivaram challa (3/26/2009)
Now, if taking log backups isn't needed, then you can do a "dbcc Shrinkfile" on the logfile when the "Log_reuse_wait_desc" in the sys.databases status is "LOG_BACKUP".
You...
March 26, 2009 at 5:02 pm
John H. Higgins (3/26/2009)
I'm pretty sure the root cause is allowing one of my users to do some editing in the back endI'm going to let it go at that.
jhh
Application-...
March 26, 2009 at 2:54 pm
Darren.Siegert (3/26/2009)
The database is a reporting mart which gets loaded with approx 200,000 records every night.
With that kind of inserts I would drop and create them. Check the...
March 26, 2009 at 12:58 pm
yulichka (3/26/2009)
Is any one can give me a good routine on the maintance jobs, every day and every week. What is first runs and last.Thank you
as always "it depends".
Check this...
March 26, 2009 at 12:49 pm
You are welcome.
SQL server automatically chooses the dead lock victim and kills the process. You do not have to but yes it is sometimes critical to know on production databases.
Have...
March 26, 2009 at 12:42 pm
Fraggle (3/26/2009)
Thanks for the updates on the flags. Good to know.Fraggle
You are welcome. and also check this blog post too:
This is a great article, you can send notifications to...
March 26, 2009 at 12:35 pm
Fraggle (3/26/2009)
As for why so many flags, I wanted to see the output of them all for an actual deadlock.
1222 would be suffice to see the actual...
March 26, 2009 at 12:21 pm
Markus (3/26/2009)
Two CPUs. One MDF and one LDF file.
Sorry to jump in between 😀
Best practice:
number of temp db data files should be = number of CPU's
March 26, 2009 at 11:59 am
That's a very clear and good explanation Lowell. 🙂
March 26, 2009 at 11:57 am
sqlsc (3/26/2009)
March 26, 2009 at 11:53 am
Viewing 15 posts - 451 through 465 (of 860 total)