Viewing 15 posts - 46,996 through 47,010 (of 49,552 total)
Which statement?
Applying tran logs in a log shipping scenario? Disaster recovery?
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
April 4, 2008 at 5:14 am
julia.nicholas (4/3/2008)
AndyD (4/2/2008)
For Logins, my advice is to stick with Windows Authentication only. That way, all logins are via domain users/groups - no logins need to be transferred.
True, but you...
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
April 4, 2008 at 3:32 am
1) It's old syntax (I think it's deprecated) with the same behaviour as Simple recovery mode.
2) Lazy writer writes dirty pages to disk based on memory pressure. Checkpoint runs from...
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
April 4, 2008 at 3:29 am
Take a backup and restore it as a new DB.
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
April 4, 2008 at 3:18 am
I assume you want to speed them up. Correct?
Is there blocking?
Is the query written optimally?
Are the indexes useful (ie, is the query using indexes).
Run the query with the 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
April 4, 2008 at 2:27 am
See if there's blocking which is causieng the query to run slower than usual
Have a look at the query itself, see if it can be optimised.
Run it with exec plan,...
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
April 4, 2008 at 1:58 am
What's the initial size for TempDB and what size is it reaching?
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
April 4, 2008 at 1:55 am
32 bit or 64 bit?
Run this, and see what the cache sizes are.
SELECT name, SUM(single_pages_kb + multi_pages_kb)/1024 AS SizeInKB
FROM sys.dm_os_memory_clerks
GROUP BY name
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
April 4, 2008 at 1:19 am
What is it doing and what should it be doing?
Some schema definitions, sample data and expected output would be useful.
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
April 4, 2008 at 12:58 am
What are you struggling with?
Does this do what you want?
CREATE TRIGGER trgCopyNewUsers
ON Users -- Table the trigger's on
FOR INSERT -- What operation it triggers on
AS
Insert into Table2 (UID)
SELECT UID
FROM...
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
April 4, 2008 at 12:46 am
You can use DTSRUNUI to get the command line of the DTS package.
It's a gui app that lets you select the server and package, set the options and parameters...
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
April 4, 2008 at 12:14 am
Have a look through the error log and post any sections that look like tehy contain errors or that you don't understand.
If you like, zip the entire error log up...
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
April 4, 2008 at 12:13 am
los (4/3/2008)
I intended on taking Gail's suggestions on indexing and applying them to the temp table but with the performance the way it is, I don't think it's necessary.
Maybe...
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
April 4, 2008 at 12:08 am
Secure your server. Make sure no one has enough rights to log on, stop the SQL instance and copy the files off.
Make sure your backups are somewhere secure (ie, can'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
April 3, 2008 at 12:54 am
sandhyarao49 (4/2/2008)
1 how can we check whether the backup is in consistent state or not
Restore it. It's the only way to be absolutely sure.
If you're using SQL 2005, have page...
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
April 3, 2008 at 12:41 am
Viewing 15 posts - 46,996 through 47,010 (of 49,552 total)