Viewing 15 posts - 17,131 through 17,145 (of 49,552 total)
???
When you restore a backup (from any version of SQL) it recreates the DB as it was at the time of backup, same number of files, same things in 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
August 16, 2012 at 4:13 am
Please don't start multiple threads for the same problem.
No more replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1343237-391-1.aspx
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
August 16, 2012 at 3:45 am
In your restore script, make sure that every file has a different physical file name. In the one you have, the mdf appears twice and the ldf appears twice. Specify...
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
August 16, 2012 at 3:43 am
Start by setting max server memory to a sensible value.
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
August 16, 2012 at 3:41 am
sqlservercentral 58005 (8/16/2012)
Thanks for the reply, and forgive the newb questioning.select * from sys.objects when logged in as website user gives a list of tables.
That means he has some...
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
August 16, 2012 at 3:41 am
As I said...
GilaMonster (8/16/2012)
That's not the CPU they are using. That's the total CPU that they used since connecting.
A sleeping connection does not use any CPU. The CPU that...
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
August 16, 2012 at 3:36 am
Update runs = query execution engine processes the update plan that was generated by the query optimiser. Runs the various operators in the query plan
Value changed by the query execution...
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
August 16, 2012 at 3:35 am
They're not 2 plans for the selects. I already said what's happening.
I strongly suggest you go and read SQL 2008 internals, chapter 9.
Repo:
DBCC FreeProcCache
go
CREATE TABLE t1 (
Col1 INT,
Col2 DATETIME DEFAULT...
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
August 16, 2012 at 3:31 am
You can't. A restore must recreate the DB as it was at the time of backup. Once restored you can then go and move objects and drop files.
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
August 16, 2012 at 3:20 am
That's not the CPU they are using. That's the total CPU that they used since connecting. The CPU was used when they ran queries. No CPU is used for a...
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
August 16, 2012 at 3:20 am
Be careful, cached plans will show the unparameterised plan shells as well as the parameterised plans, your filter's eliminating the parameterised plans.
-- AND cp.objtype = 'Adhoc'
As I said, you need...
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
August 16, 2012 at 2:59 am
A query complex enough that it doesn't qualify for autoparameterisation (and this is the point where you go to BoL to see what autoparam is)
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
August 16, 2012 at 2:28 am
In that trivial case, if they are submitted in 3 separate batches, there will be one plan (autoparameterised) used 3 times.
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
August 16, 2012 at 2:13 am
In SQL 2005 and above, unless a user has some permissions on an object, they cannot see that the object exists via the system views. So if a user (as...
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
August 16, 2012 at 2:10 am
A sleeping connection doesn't use CPU. Sleeping means it's finished running any queries and the connection is idle. eg if you open a SSMS query window, run a single query...
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
August 16, 2012 at 2:08 am
Viewing 15 posts - 17,131 through 17,145 (of 49,552 total)