Viewing 15 posts - 931 through 945 (of 1,583 total)
Has there been ANY data altering activity performed on the testing db since it was restored?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 2:42 pm
No, you need to place the query hint inside the stored-procedure itself, however you could set the TRANSACTION ISOLATION LEVEL to READ UNCOMMITTED and that will set it for the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 2:28 pm
If you create a custom alert for SQL Error # 1101 or 1105 (not sure exactly which is which, you can Google that) it will send you an alert should...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 11:29 am
There are many SQL Server Events, SQL Performance Condition Alerts, as well as WMI Events that can be set up rather easily under SQL Server Agent >> Alerts.
Settings...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 11:08 am
Also, check your SQL Logs and Windows Event Logs for unusualerrors. Sometimes "sudden" performance issues can be related to issues with the disk subsystem (i.e. RAID arrays). ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 11:02 am
Is the full backup still available? Or has it already been removed from the backup location?
Side note: Did they recently add more space to the VM? Often times when...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 10:41 am
I don't think so, but you can try. In my case, I had to restart the entire server
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 8:30 am
I was referring to sysindexes, it's eventually being replaced by sys.indexes. Or am I completely confused? :ermm:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:48 pm
Reasoning for wanted to limit frequent file growth is because of the contention created by having to grow the data/log files on the disk(s). It's often best to choose...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:13 pm
Mister Sachmo (10/31/2012)
Kraig, I was doing a straight rowcount of a 4 million row table, so that would explain the perf difference. The code I saw used SUM(1) for...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:09 pm
Can you restart the server? In all honesty if you've not changed anything on the SQL Server (or no one else has either) and a full restart doesn't correct...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 7:55 pm
Agree with what every one is saying here...you need and want SQL backups.
The "benefits" have been well mentioned here already but wanted to point out that for DBs in simple...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 7:48 pm
Sorry to ask a redundant question but can you confirm that NO mail has been sent? Or has some gone out? Do you know if anything has changed...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 7:22 pm
Anything unusual showing up in the windows event viewer under application or system? I've had an issue in the last where a dependent library (dell) bombed and had to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 6:32 pm
How have you configured your default mail profile? Verify that you have the proper server name, port number, and most importantly for these types of issues...what is your needed...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 6:11 pm
Viewing 15 posts - 931 through 945 (of 1,583 total)