Viewing 15 posts - 31 through 45 (of 115 total)
Why do you need a third party tool?
The default trace run by SQL Server itself already tracks this for you right out of the box. 😉
Database growth that is....
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 23, 2013 at 12:19 am
First of all, you need to be aware of the difference between database instance and SQL Server instance - both frequently referred to as just "instance" - a cause much...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 22, 2013 at 11:55 pm
Sound advice from Glenn Berry and I'm not aware of any good reasons not to follow it.
Restricting SQL Server's memory use may hurt performance in some cases, but allowing it...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 8, 2013 at 5:12 am
Try reading the errorlog - still accessible either by opening the errorlog file directly (it's a plain text file) or via the "Applications" tab in the windows event log. More...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 8, 2013 at 1:50 am
http://blog.sqlauthority.com/2009/10/01/sql-server-sql-server-management-studio-and-client-statistics/%5B/url%5D
And yes, the times are milliseconds. 🙂
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 8, 2013 at 1:38 am
You may also find this one useful:
http://sqlserverbuilds.blogspot.com/
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 7, 2013 at 5:00 am
DPM = Data Protection Manager for anyone who didn't know that part.
I have no experience with this myself, but my understanding is that this product works by pausing all IO...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 7, 2013 at 4:29 am
Well, he did say he wanted a Phd in database administration, not SQL Server specifically. But yes, this is a SQL Server forum and yes, the MS certifications are the...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 7, 2013 at 4:03 am
No, a shrink with no_truncate will "shrink" the data file without actually shrinking it.
I'm "impressed" that a vendor like Symantec would actually make such recommendations. I mean - you...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 4, 2013 at 6:56 am
I think now is always a good time to make improvements and a group is always more managable than having to make changes to each and every individual user account,...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 19, 2012 at 10:01 pm
Abu Dina (11/19/2012)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 19, 2012 at 3:07 pm
Abu Dina (11/19/2012)
Also, if you don't mind me asking another question:
For the built in SQL Server SA account, can I use the local server Admin as the user?[/quote]
I have no...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 19, 2012 at 9:39 am
Well, if your server is not in a domain, you will probably need an equivalent local group on this server.
I agree with SpaghettigDBA regarding disk config for tempdb: While it...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 19, 2012 at 9:26 am
Logs and data on the same drive is NOT a good setup - it's bad for both performance and integrity.
Also, while I have no objections to placing the installation files...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 19, 2012 at 6:17 am
Lee Crain (10/31/2012)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
November 1, 2012 at 3:31 am
Viewing 15 posts - 31 through 45 (of 115 total)