Viewing 15 posts - 15,166 through 15,180 (of 49,552 total)
That's too much for low memory servers and too little for high memory servers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 3:55 pm
sqlfriends (12/18/2012)
If we start web server first, then SQl server, is it going to be a problem to connect after that?
Depends on how the application is written. Ask your developers.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 3:54 pm
If the restore never finished, drop the DB and restore again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 3:54 pm
Did the restore finish without error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 1:18 pm
I prefer a conservative approach to memory. Set max server memory lower (the 40 out of 48) and if monitoring shows available memory, increase it slightly. Repeat until happy.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 1:16 pm
GSquared (12/18/2012)
Anyway. It's entertaining. For about a week. Then it gets old. Really old.
Heard the same about The Old Republic, which I'm in the process...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 11:30 am
GSquared (12/18/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 10:29 am
Schema != owner
That proc is old (pre SQL 2005) and hence changing schema and owner, before SQL 2005 they were the same thing.
Use ALTER AUTHORIZATION to change owner and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 8:55 am
safzalhussain (12/18/2012)
Please suggest the easiest method to cofigure for tracking in sql server 2005 express edition.
Triggers.
CDC and Change tracking are SQL 2008 features (you posted in a 2008 forum,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 8:40 am
abitguru (12/18/2012)
in addition, we never see in logs an error about index damage,
As I said, it's not going to be corruption. (and one does not depend on the error...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 8:28 am
I'll just repeat what I said earlier
Even with normal tables, you can't just automatically create whatever the missing index DMVs suggest, unless you want a huge amount of redundant and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 8:26 am
llevity (12/18/2012)
The procs were set to EXECUTE AS OWNER, and the database was owned by sa in our QA environment. Thanks a ton!
Execute as owner does not use the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 8:25 am
NJDave (12/18/2012)
Is my memory usage normal? Do I have a problem - what should I look into?
Yes it is. No, you do not.
At most you may want to drop...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 7:54 am
Stale statistics. Almost certainly.
It's not corruption. Corruption doesn't cause performance problems. Corruption causes severity 24 error messages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 7:53 am
Impersonation? Got procs with EXECUTE AS 'sa' in them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2012 at 7:52 am
Viewing 15 posts - 15,166 through 15,180 (of 49,552 total)