Viewing 15 posts - 856 through 870 (of 1,583 total)
In furthering what has been said regarding the execution plans: look for any lookups and/or scans on large tables, clustered indexes, etc) paying special attention to the ones that have...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2013 at 8:34 pm
Something like this would work, just tweak it to suit your needs...I do something similar to monitor the SQL Developers when they change SQL Agent Jobs 😀
CREATE TRIGGER [dbo].[tr_NewUserRecordAdded] ON...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2013 at 8:23 pm
Haven't used Backup Exec in a few years but my guess is it doesn't perform transaction log backups at all (I'm sure it physically backs up the LDF file itself,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2013 at 1:49 pm
Is the DB is simple, full, or bulk-logged mode?
If in bulk or full mode make certain you have transaction log backups running. The "standard" is typically every 15 minutes...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2013 at 9:12 am
Is the LDF file 39.3MB?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 14, 2013 at 8:41 am
Agreed. But wouldn't you agree that it would be more helpful (especially since Google is one of the best resources for finding solutions) that if you knew upfront that the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2013 at 11:28 am
GilaMonster (1/11/2013)
Please note: year old thread.
How awesome would it be for this site to have an option to "close" or "resolve" button for threads???
🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 11, 2013 at 7:14 am
Hey No problem, it worked for me in my testing so best of luck with it!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 10, 2013 at 12:10 am
I wouldn't recommend using percentages for auto growth options on such large DBs. For instance if you have a DB that's 100GB, has autogrowth set to 5%, and the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 9, 2013 at 1:40 pm
Yes it will be skewed. These types of tools need to be run for bench-marking purposes prior to anything being put on the disks (so the numbers can be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 9, 2013 at 1:07 pm
This should work...
Create a new job that has "checking" code in it that will monitor the running job. From the first job step of your existing job (or via...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 9, 2013 at 10:05 am
We have mount point, under the mount point, we have data1, data2, log1, log2, tempdbmdf1, tempdbmdf2, tempdblog1, tempdblog2,.....The tempdb's are pre-sized to say 20GB each, no auto growth set.
Log files...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 9, 2013 at 9:06 am
Under the SQL Server Agent Properties >> Alert System, have you enabled a default mail profile and selected the proper fail-safe operator?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 8, 2013 at 7:44 am
With jobs, it works (as each job/job step is a separate "batch", however when executing stored-procedures within the same session SQL processes every batch sequentially (to adhere to ACID) and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 8:41 pm
By default when installing SQL Server the built in administrators group is added into the sysadmin role, so as long as you/they can connect to the SQL Server instance with...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 7:50 pm
Viewing 15 posts - 856 through 870 (of 1,583 total)