Viewing 15 posts - 15,646 through 15,660 (of 49,552 total)
naga.rohitkumar (11/15/2012)
if possible can u please suggest the root solution and about memory and all iam not that much knowledge cause iam a L1
I have. Repeatedly.
If SQL is using too...
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
November 15, 2012 at 7:03 am
Year old thread, and the title stated SQL 2000 (where sys.objects did not exist)
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
November 15, 2012 at 4:28 am
Using a 3rd party compression tool? Got hyperbac installed?
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
November 15, 2012 at 4:07 am
Most likely full recovery model and no log backups. See the first article that Anthony posted.
One other point, a large log will no cause poor performance. Shrinking a log will...
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
November 15, 2012 at 4:05 am
It's quite common to drop or disable nonclustered indexes before a data load and rebuild or recreate them afterwards.
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
November 15, 2012 at 4:04 am
miazaidi (11/15/2012)
User would have performed large DML operation, DELETE or UPDATEShrink you database, it will reduce the size of your .ldf as well as .mdf
USE [DATABASE NAME]
GO
DBCC SHRINKDATABASE(N'DATABASE NAME' )
GO
No,...
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
November 15, 2012 at 4:03 am
Oh for ...
SQL uses large amounts of memory to speed up it's operation. 512MB is not large (10 years ago it might have been). You need to set a sensible...
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
November 15, 2012 at 4:00 am
anthony.green (11/15/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
November 15, 2012 at 3:55 am
anthony.green (11/15/2012)
Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.
Yup.
A backup that starts at 10:30 and finishes at 11:30 may...
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
November 15, 2012 at 3:42 am
naga.rohitkumar (11/15/2012)
but quite oppositely wintel team saying that of ur sqlserver.exe use more sapce it might be problem in file transfer or in any uploads
If the server is not dedicated...
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
November 15, 2012 at 3:41 am
Thank you, this is all I needed.
Row error: Object ID 292196091, index ID 1, partition ID 72057617438736384, alloc unit ID 72057617450598400 (type In-row data), page ID (7:4432313), row ID 21....
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
November 14, 2012 at 3:47 pm
Check the throughput and latency of your IO subsystem.
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
November 14, 2012 at 1:53 pm
Post the errors? I can't see your error log from here.
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
November 14, 2012 at 1:52 pm
jswong05 (11/14/2012)
You can also issue commands to clear buffer and procedure cache in server quiet time. (recommend you do so at maintenance window)
Correction. Recommend that you don't run such...
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
November 14, 2012 at 1:49 pm
Try checkDB with data purity. See if it gives you any more useful errors
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
November 14, 2012 at 12:58 pm
Viewing 15 posts - 15,646 through 15,660 (of 49,552 total)