Viewing 15 posts - 151 through 165 (of 639 total)
Use the new feature for 2005 its called database mail .
Click the sql agent and ensure to select the option to enable this.
Thats it..set up your email server and do...
June 2, 2009 at 8:26 pm
Interesting...so setting the MAX has allowed the data to be stored in buffer cache which is fetched from physical disk to reside in memory (buffer cache) so the next time...
June 1, 2009 at 5:09 pm
Tracey, it looks like this server has 16GB of memory on it. Can you confirm?
Yes this is correct 16 GIG.
Two instances of SQL - set both min to 1024 an...
June 1, 2009 at 2:35 pm
Gila.
Probably IO contention.
What do the perfmon counters Physical Disk: Avg sec/read, Avg sec/write and % idle time look like for the drives with database files?
Is this total or...
June 1, 2009 at 12:56 pm
Thanks for thread...expecting Available MBytes to be increased..during day get down to 98 MBytes.
So fixing min/max and lock in should give SQL more memory to prevent it paging o/s.
June 1, 2009 at 12:51 pm
If 64 bit you do not need to do /3gb switch in boot up and only on 32 bit is this correct.
Only on sql standard editions and not enterprise?
May 30, 2009 at 7:09 pm
Did the one guy mention raid 5...this is just for read and raid 1 for writing to?
Can someone explain the LUNS part..is there usually x number of drives at say...
May 30, 2009 at 7:01 pm
If you are seeing processes block themselves, you need to review what type of waits you are encountering. My guess would be that they are CXPACKET waits - which means...
May 29, 2009 at 8:03 pm
Is there a way to see the top blocking to kill...i had probrably 100 blocks on the database yesterday and it became very hard to see which one to kill...
May 29, 2009 at 8:00 pm
No shouldn't be because of lack of backups...1 hours is good..or could do 15 minutes if they are very big logs to keep them down a bit when backing them...
May 28, 2009 at 9:03 pm
Is it share point by any chance and they are rebuilding indexes this could take for ages.....
May 24, 2009 at 1:05 pm
Thanks that a good idea. Is there a way to clean them out without a restart of SQL Server.
May 24, 2009 at 12:59 pm
I don't think you can do master from sql 2000 to sql 2005..only version to version and same service pack.
If you need all the logins look up sp_help_revlogin and run...
May 24, 2009 at 9:01 am
Viewing 15 posts - 151 through 165 (of 639 total)