Viewing 15 posts - 42,721 through 42,735 (of 49,552 total)
Lynn Pettis (12/1/2008)
Good catch Gail. I didn't think of asking what compatibility mode the database was using.
Some of the DMVs require compat mode 90, some don't. I can never...
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 1, 2008 at 9:03 am
Just bear in mind that there is a subtle difference in behaviour between the coalesce method and the Varible IS NULL OR Variable = Column method. Specifically when 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 1, 2008 at 9:03 am
That's no a serious problem.
As the output from CheckDB said:
Run DBCC UPDATEUSAGE.
No real backups.
Why not?
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 1, 2008 at 8:48 am
If I could send a print screen I would but it is not in any of our servers right noew
It's included in all editions of SQL 2005, from enterprise right...
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 1, 2008 at 8:39 am
torpkev (12/1/2008)
Reorganize data and index pages (change free space per page percentage to 10%)
There's your culprit. Index rebuilds are fully logged and have nasty effects on a tran log.
You can...
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 1, 2008 at 7:25 am
CheckDB, when run without options, just checks for errors.
The best options for checkdb (when run as a regular integrity check) is with the ALL_ERRORMSGS and NO_INFOMSGS options.
If you get corruption,...
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 1, 2008 at 7:16 am
Are you sure your windows login is a member of the sysadmin group?
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 1, 2008 at 7:11 am
Please post in the appropriate forum.
In my opinion, the 'repair minor errors' option should not be checked. Minor corruptions may indicate larger problems in the future. If they get repaired...
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 1, 2008 at 7:10 am
All of the DMVs are present in all editions of SQL 2005.
What error are you getting?
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 1, 2008 at 7:07 am
Ow! Multi-statement table-valued functions are an absolute pain and they tend to perform very badly with larger rowsets.
How many rows do those return?
This update is not necessary. You should be...
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 1, 2008 at 7:04 am
SQL won't release memory by itself. That's by designs and it's expected behaviour. It will only release memory when the OS requests it (in cases of low memory) or when...
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 1, 2008 at 6:56 am
What you can do is just check the size of your log backups. That'll give you an easy way to get the average log volume.
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 1, 2008 at 6:29 am
KPR (12/1/2008)
sorry to reduce it to one sec.
That may not be possible. You're doing a lot of work in there.
What are these?
dbo.fn_ProfileLegalVechile(@ProfCode,@Branch)
dbo.fn_ProfileWareHouse(@ProfCode,@WHCode)
dbo.fn_ProfileCurrency(@ProfCode,@CCYCode)
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 1, 2008 at 6:26 am
KPR (12/1/2008)
Hi Chris, The prev one is the Gilamonster thread I had tried. The below one is yours I had tried.
The suggestions aren't mutually exclusive.
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 1, 2008 at 6:19 am
You could try DBCC SQLPERF(LOGSPACE) for the percentage of the file used. You could also count the rows in fn_dblog(null, null), but that can get intensive and time consuming,...
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 1, 2008 at 5:55 am
Viewing 15 posts - 42,721 through 42,735 (of 49,552 total)