Viewing 15 posts - 4,951 through 4,965 (of 19,560 total)
crookj (3/7/2013)
Daniel Bowlin (3/7/2013)
HelpSupport
Truss
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:10 pm
The log file is set to restricted growth. You may have reached that restricted growth size.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:08 pm
Ok, does the same thing happen on each node of the cluster? Just trying to get a wider picture.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:07 pm
So long as you have the tran log backups, you should be able to restore. But to play it safe, I'd keep those backups and perform copy_only backups outside...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 11:05 pm
Is SQL Server the only thing on this box or do you have other apps and things like AntiVirus installed on this box too?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:48 pm
What are the maximum values you have seen for PLE on each node?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:37 pm
Do you have your SSRS keys backed up?
Occasionally the key can become "lost" and you may need to restore it.
Here is a link concerning the issue. The first post...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:35 pm
Looks like we may have a fun day with this question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:31 pm
Hardware reserved, is that in MB or GB that you are showing?
NUMA - did you make any changes to CPU affinity or is the default setting still active (SQL Server...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:27 pm
Just curious about a couple of BIOS settings.
1. What is the hardware reserve memory set at for the server? This could be impacting your "standby" memory count.
2. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:13 pm
From the sounds of it, this is something that I'd prefer to have monitored from the task scheduler or from the OS or a service that is fairly lightweight.
That said,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 10:05 pm
Sounds like the data file has reached its max size and autogrow has been turned off. Have you tried to expand the file?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 9:57 pm
Revenant (3/7/2013)
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML. 😉
The only possible reason is so you can say your indexes are...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 9:55 pm
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML. 😉The only possible reason is so you can say your indexes are SeXI.
That and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 9:25 pm
jcrawf02 (3/7/2013)
You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then they know what they can get away with...
Basic...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2013 at 9:20 pm
Viewing 15 posts - 4,951 through 4,965 (of 19,560 total)