Viewing 15 posts - 42,226 through 42,240 (of 49,552 total)
Paul (12/19/2008)
It works happily for a few hours, then suddenly comes apart in a mass of "System.Data.SqlClient.SqlException, Timeout expired" exceptions
Sounds like the data volumes in prod are causing perf problems....
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 19, 2008 at 2:13 pm
Eric Butler (12/19/2008)
Simple question which I thought would be straight forward.Is it necessary to perform an sp_recompile after performing batch UPDATE STATISTICS operations.
No. A stats update invalidates all plans based...
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 19, 2008 at 1:56 pm
Osmar Fernandez (12/19/2008)
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 19, 2008 at 1:47 pm
Leave it at 0. No real need to fiddle with that.
The main reason to change that is for servers that have multiple instances of SQL on 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 19, 2008 at 1:43 pm
Yup, though you're probably better off using perfmon than task manager for anything other than a casual check.
And before you ask, there's no 'normal' value. It's completely dependant on your...
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 19, 2008 at 9:24 am
m3n@ce (12/19/2008)
Do I need to do a tail end backup of the transaction log before I do the restore?
Since you're not planning to restore the logs (why?) no need. Just...
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 19, 2008 at 9:18 am
sudarram (12/19/2008)
A single SPID has 1714526 Cpu.Was this a normal one?
Who knows? That's just saying how much CPU time that spid has used since it started. Without knowing what it's...
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 19, 2008 at 9:12 am
ibnzakariyyahh (12/19/2008)
i think my boss just want to punish me for this kind of assignment.
I wish I got this kind of punishment. This is dead simple and very quick.
You haven't...
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 19, 2008 at 9:11 am
sudarram (12/19/2008)
HiI'm new to SQLSERVER.What should be the Normal CPU Utilization of SQLSERVER?
Depends what the server's doing. That's kinda like asking "How long is a piece of...
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 19, 2008 at 9:08 am
Matt Miller (12/19/2008)
I'm the new kid on the block at my job this year, so I get to "keep the lights on"...
Bummer. Hope nothing breaks.
This is the first...
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 19, 2008 at 8:50 am
I'm not going to ask too much. I'd love a machine with a user interface somewhere between the one in Minority Report and the one in Quantum of Solace.
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 19, 2008 at 8:38 am
Robert Frasca (12/19/2008)
I found heap, clustered, non-clustered, and XML as the only valid "types".
Heap, no. It doesn't have the b-tree structure, it's not an index.
Don't forget spatial indexes on...
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 19, 2008 at 8:32 am
Grant Fritchey (12/19/2008)
I want to try this on my own, but I'm a bit busy. Has anyone tried querying sys.dm_exec_query_plan?
Plans are there. Fairly easy to identify too, the objectid in...
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 19, 2008 at 8:28 am
Domagoj Orec (12/19/2008)
I wonder what happens with 50+ year olds in IT, how they cope with learning new things?
My colleague's around that age and he runs rings around me...
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 19, 2008 at 8:20 am
A hardcoded password is a bad idea, for this reason and others.
You can put the password in the app.config file (encrypted) and have it different on dev and prod. Preferably...
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 19, 2008 at 8:18 am
Viewing 15 posts - 42,226 through 42,240 (of 49,552 total)