Viewing 15 posts - 61 through 75 (of 2,435 total)
hmmm ... with an active passive cluster with 64 GB of RAM the largest paging file you should have configured is either 16 or possibly 32 GB. With 99% page...
June 11, 2014 at 12:08 pm
what credentials are you using on this SQL Server ? are you in the 'sysadmin' role ?
is the server really busy ?
have you tried running the query from SQLCMD ?
June 11, 2014 at 11:44 am
silly questions:
was there a maintenance outage or down time ?
do you have the SQL Server errorlogs available ?
does your job produce an output log file ?
have you scanned the application...
June 10, 2014 at 4:18 pm
Do not 'over provision' - SQL does not like having memory and/or CPUs managed in and out.
Most applications can handle that but SQL Server really, really hates it.
In looking at...
June 10, 2014 at 4:05 pm
hmmm ... I am thinking network related here.
Have you looked at your network configuration on that server ? possibly a bad DNS search order ? or even an non-existant DNS...
June 6, 2014 at 2:59 pm
The question was cute - the correct answer is unfortunately 'obtuse' code that really has no place in a production environment.
think "Code with clarity" ...
June 5, 2014 at 7:45 am
I would also look at database size, CPU load and potentially using the Resource Governor to keep normal SQL Server performance levels within acceptable ranges.
June 4, 2014 at 12:11 pm
These are Windows Server vulnerabilities methinks - these and any other MS security hot-fixes should ALWAYS be applied.
June 4, 2014 at 11:28 am
Not at all since our SQL VM instances have resources that are fixed.
We only 'over provision' WEB, Citrix and aplication servers - NEVER SQL Servers.
June 4, 2014 at 9:45 am
Our environment is 80% virtual (550+ SQL server instances).
A previous point alluded to about SQL Server not playing well with 'others' is just not true.
SQL Server does not like having...
June 3, 2014 at 1:06 pm
What is wrong with table variables ?
hmmm ...
table variables are not capable of having indexes (however they support constraints and primary keys)
no indexes mean:
- no index statistics...
June 3, 2014 at 12:29 pm
A great list discussion - my 3 cents:
- table variables need to be depracated with extreme prejudice
- SSMS generated code (IMAX screen width anybody ?)
- UpperLowerCase as...
June 3, 2014 at 11:50 am
First a few questions:
- Is the server physical or virtual ?
- Is there an application on the database server ?
- How much RAM is on the server...
June 3, 2014 at 11:40 am
Call me 'old school' - a single 24" monitor in the office and a single 22" monitor at home.
I never open up more than 24 applications at a time (3...
June 3, 2014 at 10:07 am
WOW - 2005, 2007, 2011, 2014 - what a thread life !
May 30, 2014 at 1:05 pm
Viewing 15 posts - 61 through 75 (of 2,435 total)