http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/1924.aspxWed, 28 Feb 2007 05:31:34 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1924rsocol0http://sqlserver.ro/forums/thread/1924.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1924<p>SQL-DMO (care există începând de la SQL Server 7) este COM, iar SMO (care a apărut la SQL 2005) este .NET.</p><p>Răzvan&nbsp;</p>http://sqlserver.ro/forums/thread/1923.aspxTue, 27 Feb 2007 20:08:55 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1923crestinul0http://sqlserver.ro/forums/thread/1923.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1923<BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>xmldeveloper:</strong></div><div> <P>Personal prefer procedura stocata. Un argument pentru asta: <A class="" href="http://support.microsoft.com/kb/919609" target=_blank>FIX: The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000</A></P> <P></div></BLOCKQUOTE></P> <P>sqldom objects se acceseaza prin comuri sau e assembly dot net sau si una si alta<img src="http://sqlserver.ro/emoticons/emotion-42.gif" alt="Confused" />?</P>http://sqlserver.ro/forums/thread/1917.aspxMon, 26 Feb 2007 09:05:29 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1917rsocol0http://sqlserver.ro/forums/thread/1917.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1917<p>&gt; nu vi se pare ca unused e mult prea mic pt aceasta baza de date? <br></p><p>Nu. Era prea mare la baza mea de date (şi o să mă ocup de ea, să o defragmentez).</p><p>Răzvan</p>http://sqlserver.ro/forums/thread/1916.aspxMon, 26 Feb 2007 08:36:26 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1916Alex0http://sqlserver.ro/forums/thread/1916.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1916ah....acum am inteles&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reserved = data + index_size + unused&nbsp;&nbsp;&nbsp;&nbsp; .....nu vi se pare ca unused e mult prea mic pt aceasta baza de date?http://sqlserver.ro/forums/thread/1915.aspxMon, 26 Feb 2007 08:29:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1915Alex0http://sqlserver.ro/forums/thread/1915.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1915<P>multumesc mult pt raspunsuri</P> <P>dar mai am o intrebare...</P> <P>credeti ca ar trebui sa maresc spatiul "reserved" pt aceasta baza ....se "poarta" asa ceva....daca da, cum fac lucrul asta si la cat ar trebui marita tinand cont de dimensiunea lui "data".....nu sunt prea apropiata ca valori?...astfel si "unused" space va fi mai mare</P> <P>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fileid&nbsp;&nbsp;&nbsp; filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;filegroup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxsize&nbsp;&nbsp;&nbsp;&nbsp;growth&nbsp;&nbsp;&nbsp; usage&nbsp;&nbsp;&nbsp;&nbsp; <BR>---------------- ------ ----------------------------------------------------------------------------------------------------------------------------------------<BR>DBNAme_Data&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C:\..data\DBNAme_Data.MDF&nbsp;&nbsp;&nbsp; PRIMARY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2562752 KB&nbsp;&nbsp;&nbsp; Unlimited&nbsp;&nbsp;&nbsp; 10%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data only<BR>DBNAme_Log&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C:\..data\DBNAme_Log.LDF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 833408 KB&nbsp;&nbsp;&nbsp;&nbsp; Unlimited&nbsp;&nbsp;&nbsp;&nbsp;10%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log only</P> <P>database_name&nbsp;&nbsp;&nbsp; database_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unallocated space&nbsp; <BR>---------------------------------------------------------------------------------<BR>DBNAme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3316.56 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 421.85 MB</P> <P><BR>reserved&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unused&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>------------ ------------------ ------------------ ---------------------------<BR>2130776 KB&nbsp;&nbsp;&nbsp;&nbsp; 2095584 KB&nbsp;&nbsp;&nbsp; 3600 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31592 KB</P> <P>&nbsp;</P>http://sqlserver.ro/forums/thread/1913.aspxSun, 25 Feb 2007 12:43:10 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1913rsocol0http://sqlserver.ro/forums/thread/1913.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1913<p>Hmm... referitor la KB919609, "Typically, you experience this problem when the database size exceeds 2 terabytes.", dar oricum...</p><p>Şi eu prefer procedura respectivă (şi în general codul scris de mine, nu cel generat de diverse tool-uri), dar Alex a întrebat ce semnificaţie au informaţiile respective.</p><p>Răzvan&nbsp;</p>http://sqlserver.ro/forums/thread/1910.aspxSun, 25 Feb 2007 10:35:04 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1910xmldeveloper0http://sqlserver.ro/forums/thread/1910.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1910<P>Personal prefer procedura stocata. Un argument pentru asta: <A class="" href="http://support.microsoft.com/kb/919609" target=_blank>FIX: The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000</A></P>http://sqlserver.ro/forums/thread/1909.aspxSat, 24 Feb 2007 16:51:35 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1909rsocol0http://sqlserver.ro/forums/thread/1909.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1909<p>Informaţiile afişate în Enterprise Manager la click dreapta / Properties pe o bază de date ar trebui să fie aceleaşi cu cele returnate de <i>sp_spaceused</i> şi anume: <i>database_size</i> conţine dimensiunea totală a tuturor fişierelor (de date şi de log), iar <i>unallocated_space</i> conţine doar spaţiul nealocat din fişierele de date. </p><p>Procedura <i>sp_spaceused</i> mai precizează şi cât spaţiu este <i>reserved</i>, adică alocat unor obiecte din baza de date, dintre care: <i>data</i> este spaţiul folosit efectiv de date, <i>index</i> este spaţiul folosit de indecşii non-clustered, iar <i>unused</i> este spaţiul alocat unor obiecte, dar nefolosit din cauze de fragmentare, row size, etc.</p> <p>De exemplu, într-una din bazele mele de date am executat sp_helpfile şi sp_spaceused şi am obţinut următorul rezultat:</p> <pre><p>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fileid filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filegroup&nbsp;&nbsp;&nbsp; size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxsize&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; growth&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; usage<br>----------------- ------ ------------------------ ------------ ------------------ ------------------ ------------------ ---------<br>DataFile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C:\...\My_DB_Data.mdf&nbsp;&nbsp;&nbsp; PRIMARY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 931456 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unlimited&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data only<br>LogFile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C:\...\My_DB_Log.ldf&nbsp;&nbsp;&nbsp;&nbsp; NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 278528 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unlimited&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log only<br><br>database_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; database_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unallocated space<br>------------------ ------------------ ------------------<br>My_DB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1181.63 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 74.57 MB<br><br>&nbsp;<br>reserved&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unused<br>------------------ ------------------ ------------------ ------------------<br>855096 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 199080 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 211496 KB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 444520 KB</p> </pre><p>După cum se observă, <span style="font-style:italic;">database_size</span> este suma dimensiunilor tuturor fişierelor, fiind (931456+278528)/1024.<span style="font-style:italic;"> </span>În schimb, <span style="font-style:italic;">unnallocated space</span> este spaţiul nealocat doar din fişierul de date, fiind (931456-855096)/1024. Iar <span style="font-style:italic;">unused</span> este spaţiul "nefolosit" (care e altceva decât "nealocat") din fişierul de date, fiind 855096-199080-211496.</p><p>Răzvan<br><br></p>http://sqlserver.ro/forums/thread/1905.aspxFri, 23 Feb 2007 11:37:31 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1905xmldeveloper0http://sqlserver.ro/forums/thread/1905.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1905Folositi procedura stocata <STRONG>sp_spaceused</STRONG> pentru a determina spatiul ocupat de o baza de date sau un tabel.http://sqlserver.ro/forums/thread/1902.aspxFri, 23 Feb 2007 09:27:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1902Alex0http://sqlserver.ro/forums/thread/1902.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=1902<P>Salut, o alta nelamurire a mea este</P> <P>la click dreapta pe DB in Properties am la tabul General/Database pe langa Status,Owner etc si Size = 3445,06 MB si Space available = 1351,00 MB</P> <P>in calculul acestui Space available intra si spatiul din transaction log?</P> <P>pt ca DBName_Data&nbsp;= 2707 MB si DBName_Log&nbsp;= 739 MB&nbsp;</P>