Viewing 11 posts - 61 through 71 (of 71 total)
Thanks, do you think I should treat the tempdb the same as the other databases and put the data file on F and Log on G?
November 15, 2007 at 1:29 am
The way I did it was to run profiler from my PC monitoring only the databases I thought were not in use to see if anyone was using them.
November 14, 2007 at 9:21 am
You should size the Tempdb to a size it uses on a regular basis, if you log size stats you should analyse these to determin what size it should be,...
November 14, 2007 at 8:02 am
Thanks, I think I fixed it by removing the ones that wouldn't work and creating new ones however I don't trust it to work reliably as it seemed like such...
November 6, 2007 at 8:57 am
Do you mean you just want to gather some standard information from each server at your company?
The simplest thing to do would be to write a script to do things...
November 5, 2007 at 9:44 am
It is, it just appears to be certain alerts, I think I might delete them all and recreate them.
November 5, 2007 at 9:38 am
I added a different alert to be set off by a different error number and this works, appart from the error number the alert is configured exactly the same, even...
November 5, 2007 at 8:46 am
Yes, they're all genrated from a job that runs an SP.
November 5, 2007 at 5:16 am
When you say default global mail profile what do you mean, I've tried reconfiguring this a few times but each time I get the same results. I'm using the...
November 5, 2007 at 4:09 am
Even if you have owner rights on msdb you still can't view any maintainence plans or jobs, you need to have sysadmin.
November 2, 2007 at 2:41 am
You can only see Maintainance Plans if you have sysadmin, if you create a test user and keep assigning it different Server Roles and keep re-connecting you can see what...
October 30, 2007 at 8:26 am
Viewing 11 posts - 61 through 71 (of 71 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy