Viewing 15 posts - 22,951 through 22,965 (of 49,552 total)
If you go CAL, you'll need 100 CALs. You have 100 users accessing the database, the IIS server is not the user.
If you go processor, you'll need 2 licences, one...
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
October 13, 2011 at 11:21 pm
Roy Ernest (10/13/2011)
I am at the Presentation of Steve jones for the sql pass. MS supported event and guess what laptop Steve is using? An Apple.. 😀
And how many...
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
October 13, 2011 at 11:13 pm
Teemo (10/13/2011)
i think that would be enough for the report, thanks for the help 🙂
What? Users since the last log backup (probably less than an hour depending on log backup...
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
October 13, 2011 at 11:08 pm
george sibbald (10/13/2011)
GilaMonster (10/13/2011)
Truncate and Shrink is a very, very bad thing to be doing regularly to 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
October 13, 2011 at 8:16 am
sd 31430 (10/13/2011)
I would like to learn how to improve the performance step by step and I would be happy,...
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
October 13, 2011 at 8:15 am
How are you measuring the amount of memory used?
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
October 13, 2011 at 8:13 am
Yes, the index rebuild is causing your log to grow. It will.
Truncate and Shrink is a very, very bad thing to be doing regularly to the log, it's breaking...
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
October 13, 2011 at 8:10 am
Tune the code, tune the queries, there's no 'go faster' switch in SQL (shrink however is a very nice 'go slower' switch)
I wrote a 2-part article over at Simple Talk...
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
October 13, 2011 at 8:06 am
That reads the active portion of the transaction log. While there is a free log reader tool for SQL 2000, all you'll be able to get is the database user...
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
October 13, 2011 at 8:04 am
forsqlserver (10/13/2011)
gail may I know reason?
Because it needs to recreate the database as it was at the time of backup, a 1.6TB sized database.
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
October 13, 2011 at 8:02 am
RESTORE DATABASE .... WITH MOVE ....
Specify each file and where it goes, see Books Online for full details, I know there's an example on the Restore database page that covers...
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
October 13, 2011 at 12:17 am
That information doesn't exist unless you had a trace running at the time the procedure was created. SQL does not track it at all by default. (and before someone suggests...
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
October 13, 2011 at 12:08 am
If you are restoring that database, you need 1.6TB of space to restore it.
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
October 13, 2011 at 12:03 am
Spam. Reported. No replies please.
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
October 13, 2011 at 12:02 am
Spam. Reported. No replies please.
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
October 13, 2011 at 12:01 am
Viewing 15 posts - 22,951 through 22,965 (of 49,552 total)